SMSE05数据字典与实例优化

《SMSE05数据字典与实例优化》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、DataDictionaryContentsandUsageThedatadictionaryistherepositoryfordatabasemetadata,whichisafancytermfordatadescribingthedatabase.AfundamentaldifferencebetweenanRDBMSandotherdatabaseandfilesystemsisinthewaythattheyaccessdata.Accesstoalldatainthedatabaseismanagedbythekernel;Applicationneverwritedire

2、ctlytothedatabaseApplicationCatalogMappingsSecurityActualDataTablesIndexesOracleKernelSQLRequestsandResultsRDBMSDataDictionaryDataRepositoryCatalogMappingsSecurityObjectivesIdentifykeydatadictionarycomponentsIdentifythecontentsandusesofthedatadictionaryDescribethestatisticskeptinthedynamicperform

3、anceviewsDevelopingforperformanceOracleInstanceTuningMeasureandtunetheSGA(librarycachehitratio,dictionarycachehitratio,databuffer,…)Identifytheperformancebottleneck(s):Oracle’sWaitEvents”andOSstatisticsTuningGoalsandTechniquesQuerythedatadictionaryCreateaDatabaseCreatingandstartingoracleinstanceC

4、reatingdatabasefilesCreatingdatadictionaryviewsAddingPL/SQLsupportAddingadvancedreplicationAddingoracleJserverAddingoracleInterMediaAddingoraclespatialAddingoracleTimeSeriesAddingoraclevisualinformationretrievalAddingSQL*PlushelpDatabasecreationcompleteControlfilesDatafilesRedologfilesDatabaseDat

5、aDictionaryDatadictionarytables:DynamicperformancetablesPL/SQLpackageswerealsocreatedaswellasDatabaseeventtriggers.DataDictionaryTablesDynamicPerformanceTablesOracledisplaysdatastoragestatisticsinDBA_xxxviewsthatwillhelpyouintroubleshootingthesegments’storage(tables,clusters,andindexes)Oracleserv

6、erdisplaysallsystemstatisticsintheV$SYSSTATview,andusesmanyotherviewsforperformanceandtroubleshootinginformation.Oracle9iDatabaseReference(PartNo.A90190-02,706页):CharacteristicsoftheDataDictionaryCentraltoeveryOracleDatabaseDescribesthedatabaseanditsobjectsContainsread-onlytablesandviewsMaintaine

7、dbytheOracleserverAccessedwithSELECTStoredintheSYSTEMtablespaceOwnedbytheuserSYSControlfilesDatafilesRedologfilesDatabaseDataDictionaryTablesDataDictionaryIncludestwotypesofobjects(twolevels):Basetables(Internallevel)S