吉林大学大型数据库设计与实现dba-03.ppt

ManaginganOracleInstance

ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:CreateandmanageinitializationparameterfilesConfigureOMFStartupandshutdownaninstanceMonitorandusediagnosticfiles

OracleInstanceSGARedolog

bufferDatabuffer

cacheSharedpoolDatadict.

cacheLibrarycacheDBW0SMONPMONCKPTLGWROthersspfiledb01.oraInitializationParameterFilesSQLCONNECT/ASSYSDBASQLSTARTUP

InitializationParameterFilesEntriesarespecifictotheinstancebeingaccessedTherearetwokindsofparameters:Explicit:HavinganentryinthefileImplicit:Noentrywithinthefile,butassumingtheOracledefaultvaluesMultiplefilescanbeusedforasingledatabasetooptimizeperformanceindifferentsituations.Changestoentriesinthefiletakeeffectbasedonthetypeofinitializationparameterfileused;Staticparameterfile,PFILEPersistentparameterfile,SPFILE

PFILE

initSID.oraThePFILEisatextfilethatcanbemodifiedwithanoperatingsystemeditor.Modificationstothefilearemademanually.Changestothefiletakeeffectonthenextstartup.Itsdefaultlocationis$ORACLE_HOME/dbs.

PFILEExample#InitializationParameterFile:initdb01.oradb_name=db01instance_name=db01control_files=(/u03/oradata/db01/control01db01.ctl,/u03/oradata/db01/control02db01.ctl)db_block_size=4096db_block_buffers=500shared_pool_size=#30MSharedPooldb_files=1024max_dump_file_size=10240background_dump_dest=/u05/oracle9i/admin/db01/bdumpuser_dump_dest=/u05/oracle9i/admin/db01/udumpcore_dump_dest=/u05/oracle9i/admin/db01/cdumpundo_management=autoundo_tablespace=undtbs...

SPFILE

spfileSID.oraBinaryfilewiththeabilitytomakechangespersistentacrossshutdownandstartupMaintainedbytheOracleserverRecordsparametervaluechangesmadewiththeALTERSYSTEMcommandCanspecifywhetherthechangebeingmade