Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page