tailieunhanh - Using Data Dictionary and Dynamic Performance Views

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course. Database event triggers: Triggers are procedures that execute implicitly whenever a table or view is modified, or when some user actions or database system actions. | Using Data Dictionary and Dynamic Performance Views 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 Built-In Database Objects Other objects created with the database: Data dictionary Performance tables PL/SQL packages Database event triggers Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the script is | Using Data Dictionary and Dynamic Performance Views 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 Built-In Database Objects Other objects created with the database: Data dictionary Performance tables PL/SQL packages Database event triggers Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course. Database event triggers: Triggers are procedures that execute implicitly whenever a table or view is modified, or when some user actions or database system actions occur. Database event triggers will not be discussed within the scope of this course. 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 Data Dictionary One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables and views that provides information about its associated database. The data dictionary is updated by the Oracle server whenever a data definition language (DDL) command is executed. In addition, data .