使用数据库字典和动态性能视图.ppt

《使用数据库字典和动态性能视图.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、使用数据库字典和动态性能视图目标学完这个课程，你应该可以掌握你下内容:区别内置的数据库对象区别数据字典的内容和用法理解数据字典视图是如何创建的区别数据字典视图的种类查询数据字典和动态性能视图理解administrativescript命名规则内置的数据库对象Otherobjectscreatedwiththedatabase:DataDictionaryPerformancetablesPL/SQLpackagesDatabaseeventtriggersDataDictionaryCentraltoeveryOracledatabaseDescribesthedatabas

2、eanditsobjectsContainsread-onlytablesandviewsStoredintheSYSTEMtablespaceOwnedbytheuserSYSMaintainedbytheOracleserverAccessedwithSELECTControlfilesDatafilesRedoLogfilesDatabaseDataDictionarytablesBaseTablesandDataDictionaryViewsThedatadictionarycontainstwoparts:BasetablesStoresdescriptionof

3、thedatabaseCreatedwithCREATEDATABASEDatadictionaryviewsUsedtosimplifythebasetableinformationAccessedthroughpublicsynonymsCreatedwiththecatalog.sqlscriptCreatingDataDictionaryViewsScriptPurposecatalog.sqlCreatescommonlyuseddatadictionaryviewsandsynonymscatproc.sqlRunsscriptsrequiredforserver

4、-sidePL/SQLDataDictionaryContentsThedatadictionaryprovidesinformationabout:LogicalandphysicaldatabasestructuresDefinitionsandspaceallocationsofobjectsIntegrityconstraintsUsersRolesPrivilegesAuditingHowtheDataDictionaryisUsedPrimaryuses:Oracleserverusesittofindinformationabout:UsersSchemaobj

5、ectsStoragestructuresOracleservermodifiesitwhenaDDLstatementisexecuted.UsersandDBAsuseitasaread-onlyreferenceforinformationaboutthedatabase.DataDictionaryViewCategoriesThreesetsofstaticviewsDistinguishedbytheirscope:DBA:WhatisinalltheschemasALL:WhattheusercanaccessUSER:Whatisintheuser’ssche

6、maUSER_xxxObjectsownedbythecurrentuserALL_xxxObjectsaccessiblebythecurrentuserDBA_xxxAlloftheobjectsinthedatabaseDataDictionaryExamplesGeneralOverviewDICTIONARY,DICT_COLUMNSSchemaobjectsDBA_TABLES,DBA_INDEXES,DBA_TAB_COLUMNS,DBA_CONSTRAINTSSpaceallocationDBA_SEGMENTS,DBA_EXTENTSDatabasestru

7、ctureDBA_TABLESPACES,DBA_DATA_FILESDynamicPerformanceTablesVirtualtablesRecordcurrentdatabaseactivityContinuallyupdatedwhilethedatabaseisoperationalInformationisaccessedfrommemoryandcontrolfileUsedtomonitorandtunethedatabaseOwnedbySYSuserSynonymsbeginwit