Oracle Data Dictionary Pocket Reference

If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your work

Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples.

O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by.

Table of Contents

      Introduction  

                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  

                    Recove