Oracle Data Dictionary

by Kreines, David C.

• ISBN13: 9780596005177
• ISBN10: 0596005172
• Format: Paperback
• Copyright: 2003-05-01
• Publisher: Oreilly & Associates Inc

Summary

The data dictionary is one of the basic elements of the Oracle database that all Oracle users interact with regularly. In it there are a great many tables and views, and more are added with each new Oracle release. Trying to remember which view you need and what its correct name is can be cumbersome. Oracle Data Dictionary Pocket Reference gives DBAs and developers of any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This handy little book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples.

Author Biography

David Kreines is the Manager of Database Services for Rhodia, Inc., and author of Oracle SQL: The Essential Reference (O'Reilly Media, Inc., 2000) and coauthor of Oracle in a Nutshell (with Rick Greenwald) (O'Reilly Media, Inc., 2002), Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly Media, Inc., 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly Media, Inc., 1998). Dave has worked with Oracle as a developer and database administrator since 1985, on a wide variety of platforms, from PCs to mainframes. He is an Oracle Certified Professional, is certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and publications, both in the United States and in Europe. Dave served two terms as president of the International Oracle Users Group -Americas (IOUG-A), and spent ten years on the board of directors.

Table of Contents

Introduction	1	(1)
Acknowledgments	1	(1)
Conventions	1	(1)
What Is the Data Dictionary?	2	(1)
Sample Queries in This Book	3	(1)
Static Data Dictionary Views	4	(63)
Categories of Views	4	(2)
Commonly Used Static Data Dictionary Views	6	(58)
Change Data Capture	6	(1)
Constraints	7	(1)
Data dictionary	8	(1)
Indexes	9	(4)
Jobs and Advanced Queuing	13	(2)
Locks	15	(2)
Log groups	17	(1)
Materialized views	18	(1)
Networking and distributed transactions	19	(2)
Objects Option	21	(4)
Partitioning	25	(5)
Programming and PL/SQL	30	(4)
Replication	34	(7)
Security and auditing	41	(9)
Server information	50	(2)
SQLJ	52	(2)
Storage	54	(3)
Tables, columns, and views	57	(7)
Other Static Data Dictionary Views	64	(3)
Export/Import	64	(1)
Gateways	64	(1)
Oracle Parallel Server/Real Application Clusters	65	(1)
Remote procedure calls	65	(1)
Snapshots	66	(1)
SQL*Loader direct path	66	(1)
Tablespace point-in-time recovery	66	(1)
Dynamic Data Dictionary Views	67	(1)
Availability of Dynamic Data Dictionary Views	67	(1)
How Dynamic Data Dictionary Views Are Built	67	(2)
Global Dynamic Data Dictionary Views (GV$ Views)	69	(1)
Commonly Used Dynamic Data Dictionary Views	69	(1)
Advanced Queuing	70	(1)
Configuration	70	(1)
Data dictionary cache	74	(2)
Database	76	(4)
Instance	80	(1)
Locks and latches	80	(1)
Multi-Threaded Server/Shared Servers	85	(3)
Oracle Parallel Server/Real Application Clusters	88	(7)
Parallel Query	95	(2)
Recovery	97	(9)
Replication	106	(1)
Resource allocation	107	(1)
Security	108	(1)
Session	108	(5)
System Global Area	113	(2)
SQL	115	(9)
SQL*Loader direct path	124	(1)
System environment	125