oracle入门知识

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

Oracle8i1z0-023ArchitectureandAdministrationTestselinaOracle.................................................2ORACLESERVER..............................................5oracle............................................8................................................13..............................13..............................................15..........................................15......................................19............................................23................................................25..................................................29................................................32..........................................36................................................37............................................40....................................42................................................44................................................45................................................48........................................49Oracle1oracle1Oracle2OracleOracleSGAOracle2oracleOracleSGA3SGAOracle,OracleSGAsharedpool:SQLSQLSHARED_POOL_SIZE,Librarycache:SQL,SQLSQL,SQLDatadictionarycacheSQLdatabasebuffercache:DB_BLOCK_SIZE.2DB_BLOCK_BUFFERSRedoLogBUFFER:LOG_BUFFER,,SGAJavaJavaLargePool:SQLDBWR_IO_SLAVESBACKUP_TAPE_IO_SLAVESRMANDBWR_IO_SLAVES:DBWnI/Oslaves0I/Oslaves0ARCnprocess,LGWRprocessRMAN4I/OslavesI/OBACKUP_TAPE_IO_SLAVES:RMANI/OslavesFALSE(thedefault),shadowprocessprocessSizingtheLargePoolLARGE_POOL_SIZELargePoolOraclesharedpoolalter.log4a)(DBWR),DBWR()b)(LGWR),LGWR1MBDBW0e)(SMON)f)(PMON)Oracle3g)(CKPT),LOG_CHECKPOINT_INTERVALARCDBAARCARC5SQLa)SQLSQLSQLSQLb)DML:DML-c)6PGA---SGAPGAPGAPGASortareaSQLSessioninformationCursorstateSQLStackspace748Oraclea)b),Oracle(SCN)SCNOracleSCNOraclec)COMMITSCNLGWR()COMMITDBW0ORACLESERVER1WindowsNTsetup.exeresponsefilefilename[-silent][-nowelcome]setup.exeProgramFilesOracleouiinstallSolarisrunInstaller-responsefilefilename[-silent][-nowelcome]runInstallerINSTALLinstallsolaris2(OFA)OFAOracle5OracleNTUNIXOracleOracle3SYSSYSTEMsys:DBA,SYS:change_on_installsystem:DBAOracle:manager4a)UNIXdbaNET8tcp/ip,decnetREMOTE_LOGIN_PASSWORDFILENONE8.1.xEXCLUSIVEOracleNONENT:SQLNET.AUTHENTICATION_SERVICES=(NTS)UNIX:SQLNET.AUTHENTICATION_SERVICES=(ALL)or:a)CONNECT/ASSYSDBAb)CONNECT/ASSYSOPERb):$orapwdfile=$ORACLE_HOME/dbs/orapwSIDpassword=adminentries=10NT:SQLNET.AUTHENTICATION_SERVICES=(NONE,all)orUNIX:SQLNET.AUTHENTICATION_SERVICES=(NONE,NTS)REMOTE_LOGIN_PASSWORDFILEEXCLUSIVESHAREDEXCLUSIVE,SYSINTERNALSHAREDSYSINTERNAL6:CONNECTsystem/manageNT%ORACLE_HOME%DATABASENTORA_SID_PWFILEUNIX:UNIX$ORACLE_HOME/dbs5OracleEnterpriseManagera),()OracleEnterpriseManagerOracleEnterpriseManagerOracleEnterpriseManagerDBAManagementPackDBA:AdvancedManagementPacks:TuningPackOracleExpertOracleTablespaceManagerSQLAnalyzeSQLDiagnosticsPackOracleTraceDataViewerNet8PerformanceManagerCapacityPlannerTopSessionsAdvancedEventsOracleEnterpriseManagerChangeManagementPackDatabaseCaptureDatabaseDiffDatabaseQuickChangeDatabaseAlterDatabasePropagatePlanManagerApplicationManagementPack:OracleApplicationsConcurrentManagerWebFormServersWorkflowb)OracleEnterpriseManager:OMSOracleEnterpriseManager:sysman/oem_tempc:OracleEnterpriseManager:OracleEnterpriseManagerWeb7CPUd)DBAOracleEnterpriseManagerInstanceManagerSecurityManagerStorageManagerSchemaManagerSQL*PlusWorksheetSQLPL/SQLSQL*PlusDBAstartupshutdownoracle1startinstanceinitsid.oraSGAALERTview:V$SGAV$INSTANCEmountinstance,Oracle(SMON)StartupSTARTUP[FORCE][RESTRICT][PFILE=filename][OPEN[RECOVER][database]|MOUNT|NOMOUNT]:OPEN:8MOUNT:DBANOMOUNT:SGAPFILE=parfile:FORCE:RESTRICT:RESTRICTEDSESSIONRECOVER:2OracleOracleOracleALERTSGAshutdownSHUTDOWN[NORMAL|TRANSACTIONAL|IMMEDIATE|ABORT]AITNxxxxxxx0xx00x000normal()OracleOracle---OracleSQLOracleOracleOracleOracleSQLOracleNTOracleServiceSIDOracleStartSIDorashut.bat9orOracleServiceSIDORA_SID_SHUTDOWNTrue3a)(SGA),ALERTb)#IFILEc)BACKGROUND_DUMP_DEST:(LGWRDBWn)COMPATIBLE:8.1.0CONTROL_FILES:DB_BLOCK_BUFFERS:SGADB_NAME:88SHARED_POOL_SIZE:USER_DUMP_DEST:d)IFILE,LOG_BUFFERSGAMAX_DUMP_FILE_SIZEPROCESSESSQL_TRACESQLTIMED_STATISTICS4oracleNT:oracle8iOracleServiceSID:SIDOracleStartSIDstrtSID.cmd8iOracleServiceSIDSIDORA_SID_AUTOSTARTTrue510ALTERDATABASENOMOUNTMOUNT:ALTERDATABASEdatabaseMOUNT;:ALTERDATABASEdatabaseOPENREADONLY;ALTERDATABASEOPEN[READWRITE|READONLY]READWRITE,READONLY:6:V$,nomountV$FIXED_TABLENOMOUNTV$PARAMETER:V$SGA:SGAV$OPTION:OracleV$PROCESS:V$SESSION:V$VERSION:V$INSTANCE:MOUNTV$THREAD:V$CONTROLFILE:NOMOUNTV$DATABASE:V$DATAFILE:V$DATAFILE_HEADER:V$LOGFILE:7ALTERSESSIONALTERSYSTEMALTERSYSTEMDEFERREDALTERSESSIONALTERSYSTEMALTERSYSTEMDEFERREDV$PARAMETERV$SYSTEM_PARAMETERSQLSELECTisses_modifiable,issys_modifiable,ismodified,nameFROMv$system_parameterWHEREismodified!='FALSE';ISSES_MODIFIABLEALTERSESSIONISSYS_MODIFIABLEALTERSYSTEMISMODIFIEDALTERSESSIONMODIFIEDALTERSYSTEMSYS_MODIFIED11V$PARAMETERV$SYSTEM_PARAMETERALTERSYSTEMDEFERREDALTERSYSTEMALTERSYSTEMDEFERREDALERT81STARTUP:STARTUPRESTR

1 / 51
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功