Oracle数据库DBA基本技能.ppt

《Oracle数据库DBA基本技能.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、主要内容Oracle数据库的组成结构管理临时表空间加快索引的创建使用SPFILE作为初始化参数文件使用Profile加强数据库安全监控系统的锁资源争用SQL语句调优Oracle数据库的基本结构Oracle服务器AnOracleserver:Isadatabasemanagementsystemthatprovidesanopen,comprehensive,integratedapproachtoinformationmanagementConsistsofanOracleinstanceandanOracledata

2、baseOracleserverPasswordfileOracle服务器的主要组件InstanceSGARedoLogBufferSharedPoolDataDictionaryCacheLibraryCacheDBWRSMONPMONCKPTLGWROthersUserprocessServerprocessPGAControlfilesDatafilesDatabaseDatabaseBufferCacheRedoLogfilesJavaPoolLargePoolParameterfileArchive

3、dLogfilesOracle实例AnOracleinstance:IsameanstoaccessanOracledatabaseAlwaysopensoneandonlyonedatabaseConsistsofmemoryandbackgroundprocessstructuresBackgroundprocessstructuresMemorystructuresInstanceSGARedoLogBufferSharedPoolDataDictionaryCacheLibraryCacheDBWRSMON

4、PMONCKPTLGWROthersDatabaseBufferCacheJavaPoolLargePoolOracleDatabaseAnOracledatabase:IsacollectionofdatathatistreatedasaunitConsistsofthreefiletypesPasswordfileParameterfileArchivedLogfilesControlfilesDatafilesRedoLogfilesOracleDatabase建立一个数据库连接ConnectingtoanOr

5、acleinstance:EstablishingauserconnectionCreatingasessionSessioncreatedDatabaseuserUserprocessServerprocessConnectionestablishedOracleserver用户进程AprogramthatrequestsinteractionwiththeOracleserverMustfirstestablishaconnectionDoesnotinteractdirectlywiththeOraclese

6、rverDatabaseuserServerprocessUserprocessConnectionestablished服务器进程AprogramthatdirectlyinteractswiththeOracleserverFulfillscallsgeneratedandreturnsresultsCanbededicatedorsharedserverConnectionestablishedSessioncreatedDatabaseuserUserprocessServerprocessOracl

7、eserver服务器进程sdjf_dom2_srv4:/oracle>ps-ef

8、greporacleoracle290415023798660Jan27-0:06oraclejzjf2(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))oracle38667221008:50:21-0:00oraclejzjf1(LOCAL=NO)oracle38708461011:34:20-0:00oraclejzjf1(LOCAL=NO)oracle38953881002:37:3

9、5-0:00oraclejzjf1(LOCAL=NO)oracle39036521020:14:28-1:28oraclejzjf1(LOCAL=NO)进程的所有者通常为oracle用户进程的名称为：oracleSID可以被安全的kill服务器进程sdjf_dom2_srv4:/oracle>topasNamePIDCPU%PgS