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

使用数据库字典和动态性能视图 第1页，共20页。 目标学完这个课程，你应该可以掌握你下内容:区别内置的数据库对象区别数据字典的内容和用法理解数据字典视图是如何创建的区别数据字典视图的种类查询数据字典和动态性能视图理解administrative script 命名规则第2页，共20页。 内置的数据库对象Other objects created with the database:Data DictionaryPerformance tablesPL/SQL packagesDatabase event triggers第3页，共20页。 Data DictionaryCentral to every Oracle databaseDescribes the database and its objectsContains read-only tables and viewsStored in the SYSTEM tablespaceOwned by the user SYSMaintained by the Oracle serverAccessed with SELECTControl filesData files Redo Log filesDatabaseData Dictionarytables第4页，共20页。 Base Tables and Data Dictionary ViewsThe data dictionary contains two parts:Base tablesStores description of the databaseCreated with CREATE DATABASEData dictionary viewsUsed to simplify the base table informationAccessed through public synonymsCreated with the catalog.sql script第5页，共20页。 Creating Data Dictionary ViewsScript Purposecatalog.sql Creates commonly used data dictionary views and synonymscatproc.sql Runs scripts required for server-side PL/SQL第6页，共20页。 Data Dictionary ContentsThe data dictionary provides information about:Logical and physical database structuresDefinitions and space allocations of objectsIntegrity constraintsUsersRolesPrivilegesAuditing第7页，共20页。 How the Data Dictionary is UsedPrimary uses: Oracle server uses it to find information about:UsersSchema objectsStorage structuresOracle server modifies it when a DDL statement is executed.Users and DBAs use it as a read-only reference for information about the database.第8页，共20页。 Data Dictionary View CategoriesThree sets of static viewsDistinguished by their scope: DBA: What is in all the schemasALL: What the user can accessUSER: What is in the user’s schemaUSER_xxx Objects owned by the current userALL_xxx Objects accessible by the current userDBA_xxx All of the objects in the database第9页，共20页。 第10页，共20页。 Data Dictionary ExamplesGeneral OverviewDICTIONARY, DICT_COLUMNSSchema objects DBA_TABLES, DBA_INDEXES, DBA_TAB_COLUMN