Oracle data dictionary : pocket reference / David C. Kreines.

Format:

Book

Author/Creator:

Kreines, David C.

Language:

English

Subjects (All):

Oracle (Computer file).

Database management.

Physical Description:

1 online resource (146 p.)

Edition:

First edition.

Place of Publication:

Sebastopol, California : O'Reilly, 2003.

Language Note:

English

System Details:

text file

Summary:

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 w

Contents:

Contents; Oracle Data Dictionary Pocket Reference; Introduction; Acknowledgments; Conventions; What Is the Data Dictionary?; Sample Queries in This Book; Static Data Dictionary Views; Categories of Views; Commonly Used Static DataDictionaryViews; 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 ViewsExport/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 ViewsAreBuilt; Global Dynamic Data Dictionary Views (GV Views); Commonly Used Dynamic DataDictionaryViews; Advanced Queuing; Configuration; Data dictionary cache; Database; Instance; Locks and latches; Multi-Threaded Server/Shared Servers; Oracle Parallel Server/Real Application Clusters

Parallel QueryRecovery; Replication; Resource allocation; Security; Session; System Global Area; SQL; SQL*Loader direct path; System environment; Index

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 3, 2013).

ISBN:

9781449366803

1449366805

9781449313951

1449313957

9781306810340

1306810345

9780596528829

0596528825

OCLC:

757516292