5
Copyright © Oracle Corporation, 2002. All rights reserved.
Using Data Dictionary
and Dynamic Performance Views
5-2 Copyright © Oracle Corporation, 2002. All rights reserved.
Objectives
After completing this lesson, you should be able to do
the following:
•Identify built-in database objects
•Identify the contents and uses of the data dictionary
•Describe how data dictionary views are created
•Identify data dictionary view categories
•Query the data dictionary and dynamic performance
views
•Describe administrative script naming conventions
5-3 Copyright © Oracle Corporation, 2002. All rights reserved.
Built-In Database Objects
Other objects created with the database:
•Data dictionary
•Performance tables
•PL/SQL packages
•Database event triggers
5-4 Copyright © Oracle Corporation, 2002. All rights reserved.
Data Dictionary
•Central to every Oracle database
•Describes the database and its objects
•Contains read-only tables and views
•Stored in the SYSTEM tablespace
•Owned by the user SYS
•Maintained by the Oracle server
•Accessed with SELECT Control
files
Data
files Redo
Log
files
Database
Data Dictionary
tables
5-5 Copyright © Oracle Corporation, 2002. All rights reserved.
Base Tables and Data Dictionary Views
The data dictionary contains two parts:
•Base tables
–Stores description of the database
–Created with CREATE DATABASE
•Data dictionary views
–Used to simplify the base table information
–Accessed through public synonyms
–Created with the catalog.sql script