Oracle Data Dictionary Pocket Reference
Views, Columns & Tips
1st Edition
Published on 3. June 2003
Book
Paperback/Softback
144 pages
978-0-596-00517-7 (ISBN)
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. This 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. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your work. The book 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.
More details
Edition
1., Aufl.
Language
English
Place of publication
Sebastopol
United States
Target group
College/higher education
Professional and scholarly
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 177 mm
Width: 109 mm
Thickness: 14 mm
Weight
133 gr
ISBN-13
978-0-596-00517-7 (9780596005177)
Schweitzer Classification
Other editions
Additional editions
E-Book
04/2003
1st Edition
O'Reilly
€7.99
Available for download
E-Book
04/2003
O'Reilly
€6.49
Available for download
Person
David C. Kreines is the Manager of Database Services for Rhodia, Inc., a subsidiary of Rhone-Poulenc S.A., and author of Oracle SQL: The Essential Reference (O'Reilly & Associates, 2000) and coauthor of Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly & Associates, 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly & Associates, 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.
Content
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 Recovery Replication Resource allocation Security Session System Global Area SQL SQL*Loader direct path System environment