欢迎来到天天文库
浏览记录
ID:79077832
大小:853.00 KB
页数:35页
时间:2022-02-09
《oracle体系结构》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、OracleArchitecturalComponents网络通讯室王鹏飞ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:OutlinetheOraclearchitectureanditsmaincomponentsListthestructuresinvolvedinconnectingausertoanOracleinstanceOverviewofPrimaryComponentsInstanceSGARedologbuffercacheSharedpoolDataDi
2、ct.cacheLibrarycacheDBWRSMONPMONCKPTLGWROthersUserprocessServerprocessPGAControlfilesDatafilesArchivedlogfilesParameterfilePasswordfileRedologfilesDatabaseDatabasebuffercacheOracleServerAnOracleserver:Isadatabasemanagementsystemthatprovidesanopen,comprehensive,integratedapproachtoinfo
3、rmationmanagementConsistsofanOracleinstanceandanOracledatabaseOracleServerOracleInstanceAnOracleinstance:IsameanstoaccessanOracledatabaseAlwaysopensoneandonlyonedatabaseConsistsofmemoryandprocessstructuresEstablishingaConnectionandCreatingaSessionConnectingtoanOracleinstanceconsistsof
4、establishingauserconnectionandcreatingasession.ConnectionestablishedSessioncreatedDatabaseuserUserprocessOracleserverServerprocessOracleDatabaseAnOracledatabase:IsacollectionofdatathatistreatedasaunitConsistsofthreefiletypesControlfilesDatafilesArchivedlogfilesParameterfilePasswordfil
5、eRedologfilesOracleDatabasePhysicalStructureThephysicalstructureofanOracledatabaseisdeterminedbytheoperatingsystemfilesthatprovidetheactualphysicalstoragefordatabaseinformation.ControlfilesDatafilesRedologfilesControlfilesDatafiles(includesdatadictionary)HeaderOnlineredologfiles)Memor
6、yStructureOracle’smemorystructureconsistsoftwomemoryareasknownas:SystemGlobalArea(SGA):Allocatedatinstancestartup,andisafundamentalcomponentofanOracleInstanceProgramGlobalArea(PGA):AllocatedwhentheserverprocessisstartedSystemGlobalArea(SGA)TheSGAconsistsofseveralmemorystructures:Share
7、dpoolDatabasebuffercacheRedologbufferOtherstructures(e.g.lockandlatchmanagement,statisticaldata)TherearetwooptionalmemorystructuresthatcanbeconfiguredwithintheSGA:LargepoolJavapoolSystemGlobalArea(SGA)SGAisdynamicandsizedusingSGA_MAX_SIZE.SGAmemoryallocatedandtrackedingranulesbySGAcom
8、ponen
此文档下载收益归作者所有