Introduction to the Data Dictionary One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables that provides information about the database. Not only is the data dictionary central to every Oracle database, it is an important tool for all users, from end users to application designers and database administrators. Use SQL statements to access the data dictionary. Only Oracle should write to and read these tables.
|Published (Last):||24 April 2005|
|PDF File Size:||16.73 Mb|
|ePub File Size:||15.3 Mb|
|Price:||Free* [*Free Regsitration Required]|
Built as a multimedia web page, this diagram provides descriptions of database architectural components, as well as references to relevant documentation. Use this helpful reference as a cheat sheet for writing custom data dictionary scripts, locating views pertinent to a specific database component or category, understanding the database architecture, and more.
This essential reference includes: DBA Views: Key DBA static data dictionary views and dynamic performance views organized by product feature areas Performance Views: Dynamic performance views organized by product feature areas.
Click on a view and see the details for that view. Architecture Views: A single diagram that illustrates the relationships between key database dictionary views. Click on a view and see the definition for that view. Database Architecture: A single diagram that illustrates the relationships between key database memory structures, processes, and storage.
Click on the diagram to find out detailed information. Multitenant Architecture: A single diagram that illustrates the architecture for a multitenant container database. Background Processes: A comprehensive list that categorizes the background processes and flags which are new in Oracle Database 12c.
Download Information You can download and unzip this file to run the poster locally. Open the file poster. Additional Information: Please note that initial loading of the poster may take seconds.
If you experience performance problems, see the Download Information section above. Firefox v22 or later is the recommended browser. Earlier versions may work as well. We welcome your feedback to help us improve this tool. Release Date: JUL
Join the world’s largest interactive community dedicated to Oracle technologies.
Catalog Views / Data Dictionary Views
Subscribe to RSS
Data Dictionary Oracle 12c poster