欢迎来到天天文库
浏览记录
ID:52267855
大小:806.51 KB
页数:70页
时间:2020-04-03
《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
此文档下载收益归作者所有