使用數(shù)據(jù)庫(kù)字典和動(dòng)態(tài)性能視圖

目標(biāo)學(xué)完這個(gè)課程，你應(yīng)該可以掌握你下內(nèi)容:區(qū)別內(nèi)置的數(shù)據(jù)庫(kù)對(duì)象區(qū)別數(shù)據(jù)字典的內(nèi)容和用法理解數(shù)據(jù)字典視圖是如何創(chuàng)建的區(qū)別數(shù)據(jù)字典視圖的種類查詢數(shù)據(jù)字典和動(dòng)態(tài)性能視圖理解administrativescript命名規(guī)則內(nèi)置的數(shù)據(jù)庫(kù)對(duì)象Otherobjectscreatedwiththedatabase:DataDictionaryPerformancetablesPL/SQLpackagesDatabaseeventtriggersDataDictionaryCentraltoeveryOracledatabaseDescribesthedatabaseanditsobjectsContainsread-onlytablesandviewsStoredintheSYSTEMtablespaceOwnedbytheuserSYSMaintainedbytheOracleserverAccessedwithSELECTControlfilesDatafilesRedoLogfilesDatabaseDataDictionary

tablesBaseTablesandDataDictionaryViewsThedatadictionarycontainstwoparts:BasetablesStoresdescriptionofthedatabaseCreatedwithCREATEDATABASEDatadictionaryviewsUsedtosimplifythebasetableinformationAccessedthroughpublicsynonymsCreatedwiththecatalog.sqlscriptCreatingDataDictionaryViewsScript Purposecatalog.sql Createscommonlyuseddatadictionary viewsandsynonymscatproc.sql Runsscriptsrequiredforserver-side PL/SQLDataDictionaryContentsThedatadictionaryprovidesinformationabout:LogicalandphysicaldatabasestructuresDefinitionsandspaceallocationsofobjectsIntegrityconstraintsUsersRolesPrivilegesAuditingHowtheDataDictionaryisUsedPrimaryuses:Oracleserverusesittofindinformationabout:UsersSchemaobjectsStoragestructuresOracleservermodifiesitwhenaDDLstatementisexecuted.UsersandDBAsuseitasaread-onlyreferenceforinformationaboutthedatabase.DataDictionaryViewCategoriesThreesetsofstaticviewsDistinguishedbytheirscope:DBA:WhatisinalltheschemasALL:WhattheusercanaccessUSER:Whatisintheuser’sschemaUSER_xxxObjectsownedbythecurrentuserALL_xxxObjectsaccessiblebythecurrentuserDBA_xxxAlloftheobjectsinthedatabaseDataDictionaryExamplesGeneralOverviewDICTIONARY,DICT_COLUMNSSchemaobjectsDBA_TABLES,DBA_INDEXES,DBA_TAB_COLUMNS,DBA_CONSTRAINTSSpaceallocationDBA_SEGMENTS,DBA_EXTENTSDatabasestructureDBA_TABLESPACES,DBA_DATA_FILESDynamicPerformanceTablesVirtualtablesRecordcurrentdatabaseactivityContinuallyupdatedwhilethedatabaseisoperationalInformationisaccessedfrommemoryandcontrolfileUsedtomonitorandtunethedatabaseOwnedbySYSuserSynonymsbeginwithV$ListedinV$FIXED_TABLEDynamicPerformanceTableExamplesV$CONTROLFILEV$DATABASEV$DATAFILEV$INSTANCEV$PARAMETERV$SESSIONV$SGA$SPPARAMETERV$TABLESPACEV$THREADV$VERSIONAdministrativeScriptsNamingConventionsConventioncat*.sqldbms*.sqlprvt*.plbutl*.sqlDescriptionCataloganddatadictionaryinformationDatabasepackagespecificationsWrappeddatabasepackagecodeViewsandtablesfordatabaseutilitiesSummaryInthislesson,youshouldhavelearnedhowto:Identifybuilt-indatabaseobjectsIdentifythecontentsandusesofthedatadictionaryUnderstandhowdatadictionaryviewsarecreatedIdentifydatadictionaryviewcategoriesQuerythedatadictionaryanddynamicperformanceviewsUnderstandadministrativescriptnam