Book description
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 workOracle 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.
Publisher resources
Table of contents
- Oracle Data Dictionary Pocket Reference
- 1. Introduction
-
2. Static Data Dictionary Views
- Categories of Views
-
Commonly Used Static Data Dictionary Views
- Change Data Capture
- Constraints
- Data dictionary
- Indexes
- Jobs and Advanced Queuing
- 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
-
3. 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
- Index
- About the Author
- Copyright
Product information
- Title: Oracle Data Dictionary Pocket Reference
- Author(s):
- Release date: April 2003
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449366803
You might also like
book
The Relational Database Dictionary, Extended Edition
Chris Date, one of the founders of the relational model, has updated and expanded his relational …
book
The Relational Database Dictionary
Avoid misunderstandings that can affect the design, programming, and use of database systems. Whether you're using …
book
The New Relational Database Dictionary
No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over …
book
Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency
Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This …
