Chapter 5. Data Dictionary Content and Usage

Terms you'll need to understand:

• Data dictionary

• catalog.sql

• catproc.sql

• Dynamic performance views

• DBA_ views

• USER_ views

• ALL_ views

• V$ views

Concepts you'll need to master:

• Identify key data dictionary components.

• Identify the contents of the data dictionary.

• Identify the uses of the data dictionary.

• Query the data dictionary.

The data dicntionary is one of the most powerful and often relied on components of the Oracle database. This chapter introduces the data dictionary and how you can gain valuable information from this resource.