Oracle in a Nutshell

Chapter 6. Data Dictionary

The Oracle data dictionary is a collection of tables and related views that enable you to see the inner workings and structure of the Oracle database. By querying these views, you can obtain information about every object and every user of the database. All of the Oracle monitoring tools look at the information available in the data dictionary and present it in an easy-to-use format.

Traditionally, the data dictionary has consisted of a series of views owned by the SYS user. These views, known as static data dictionary views, present information contained in tables that are updated when Oracle processes a DDL statement. The SYS tables and views, as well as a set of public synonyms for the views, are all created by the catalog.sql script. In addition, the installation of some Oracle features creates tables and views in the SYSTEM schema. In general, tables and views owned by SYSTEM exist to support functionality provided by PL/SQL stored procedures (described in Chapter 9) rather than fundamental Oracle functionality.

A second set of views is known as the dynamic performance data dictionary views, commonly referred to as the V$ views. These V$ views are based on a set of internal memory structures maintained by Oracle as virtual tables, which all begin with an “X$” prefix. Just as the static data dictionary views provide information about the database, the V$ views and underlying X$ tables provide information about the active instance.