oracle数据库dba基本技能

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

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

2、cledatabaseOracleserverPasswordfileOracle服务器的主要组件InstanceSGARedoLogBufferSharedPoolDataDictionaryCacheLibraryCacheDBWRSMONPMONCKPTLGWROthersUserprocessServerprocessPGAControlfilesDatafilesDatabaseDatabaseBufferCacheRedoLogfilesJavaPoolLargePoolParame

3、terfileArchivedLogfilesOracle实例AnOracleinstance:IsameanstoaccessanOracledatabaseAlwaysopensoneandonlyonedatabaseConsistsofmemoryandbackgroundprocessstructuresBackgroundprocessstructuresMemorystructuresInstanceSGARedoLogBufferSharedPoolDataDictionaryCach

4、eLibraryCacheDBWRSMONPMONCKPTLGWROthersDatabaseBufferCacheJavaPoolLargePoolOracleDatabaseAnOracledatabase:IsacollectionofdatathatistreatedasaunitConsistsofthreefiletypesPasswordfileParameterfileArchivedLogfilesControlfilesDatafilesRedoLogfilesOracleDatab

5、ase建立一个数据库连接ConnectingtoanOracleinstance:EstablishingauserconnectionCreatingasessionSessioncreatedDatabaseuserUserprocessServerprocessConnectionestablishedOracleserver用户进程AprogramthatrequestsinteractionwiththeOracleserverMustfirstestablishaconnectionDoe

6、snotinteractdirectlywiththeOracleserverDatabaseuserServerprocessUserprocessConnectionestablished服务器进程AprogramthatdirectlyinteractswiththeOracleserverFulfillscallsgeneratedandreturnsresultsCanbededicatedorsharedserverConnectionestablishedSessioncreatedD

7、atabaseuserUserprocessServerprocessOracleserver服务器进程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:2

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