Skip to content

Oracle Data Dictionary Pocket Reference Views, Columns and Tips

Best in textbook rentals since 2012!

ISBN-10: 0596005172

ISBN-13: 9780596005177

Edition: 2003

Authors: David C. Kreines

List price: $9.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $9.95
Copyright year: 2003
Publisher: O'Reilly Media, Incorporated
Publication date: 5/20/2003
Binding: Paperback
Pages: 144
Size: 4.17" wide x 6.97" long x 0.47" tall
Weight: 0.396

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…    

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