Oracle Data Dictionary : Pocket Reference

個数:

Oracle Data Dictionary : Pocket Reference

  • 提携先の海外書籍取次会社に在庫がございます。通常2週間で発送いたします。
    重要ご説明事項
    1. 納期遅延や、ご入手不能となる場合が若干ございます。
    2. 複数冊ご注文の場合、分割発送となる場合がございます。
    3. 美品のご指定は承りかねます。
  • 製本 Paperback:紙装版/ペーパーバック版
  • 言語 ENG,ENG
  • 商品コード 9780596005177
  • DDC分類 005

Full 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.

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 65 (1)
Clusters
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 67 (1)
Views
How Dynamic Data Dictionary Views Are 67 (2)
Built
Global Dynamic Data Dictionary Views (GV$ 69 (1)
Views)
Commonly Used Dynamic Data Dictionary 69 (1)
Views
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 88 (7)
Clusters
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