Description
Book SynopsisThis dictionary is a collection of tables and related views that allow DBAs and developers to examine various aspects of the Oracle database. It's something every Oracle user should find useful to access on a regular basis.
Table of ContentsIntroduction Acknowledgments Conventions What Is the Data Dictionary? Sample Queries in This Book Static Data Dictionary Views Categories of Views Commonly Used Static Data Dictionary Views Change Data Capture Constraints Data dictionary Indexes Jobs and Advanced Queuin Locks Log groups Materialized views Networking and distributed transactions Objects Option Partitioning Programming and PL/SQL Replication Security and auditing Server information SQLJ Storage Tables, columns, and views Other Static Data Dictionary Views Export/Import Gateways Oracle Parallel Server/Real Application Clusters Remote procedure calls Snapshots SQL*Loader direct path Tablespace point-in-time recovery Dynamic Data Dictionary Views Availability of Dynamic Data Dictionary Views How Dynamic Data Dictionary Views Are Built Global Dynamic Data Dictionary Views (GV Views) Commonly Used Dynamic Data Dictionary Views Advanced Queuing Configuration Data dictionary cache Database Instance Locks and latches Multi-Threaded Server/Shared Servers Oracle Parallel Server/Real Application Clusters Parallel Query Recovery Replication Resource allocation Security Session System Global Area SQL SQL*Loader direct path System environment