Written by the world's most widely-read DBA and author of over 20 Oracle books, Mike Ault shares his secrets for Oracle DBA management scripts.  This handy reference is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts.

This stellar book comes complete with an online code depot full of over 200 pre-tested Oracle DBA scripts, and covers all areas of Oracle database administration including data files, tablespace, table and index management scripts.  Based on more than 20 years full-time experience, Mike Ault brings his expertise to the public with this fantastic book.  Your time savings from a single script is worth the price of this great book.

Key Features:

• Presents a complete guide to using Oracle internal tricks for database administration activities.

• Describes secret scripts for monitoring and tuning Oracle databases.

• Presents a framework for automatic database administration without buying expensive tools.

• Provides expert insights into the internal working of the Oracle database.

• Reviews mechanisms for automating Oracle database administration tasks.

• Comes with a complete code depot of working Oracle scripts.

Table of Contents:

 

Chapter 1 - Instance Internals Scripts   Monitoring Control Files and Initialization Parameters               Monitoring Control Files               Monitoring Database Initialization Parameters               Monitoring Undocumented Initialization Parameters Monitoring Locks and Latches               Monitoring Sessions Causing Blocked Locks               Monitoring DDL and DML Locks               Monitoring Internal Locks Monitoring Waits Monitoring Events Workspaces in Oracle9i   Chapter 2 - Inside the Shared Pool   Monitoring and Tuning the Shared Pool     Conclusions about the Shared Pool             Guideline 1             Guideline 2             Guideline 3 Pinning the PL/SQL Packages in the Shared Pool The Shared Pool and the MTS             Large Pool Sizing Disk IO and the Shared Pool Monitoring Library and Data Dictionary Caches             Guideline 7 Shared Pool Summary   Chapter 3 - Data Buffer Internals Scripts    Classic DB Block Buffer Tuning  Tuning the Multi-part Oracle8 Buffer Cache              Use of the Default Pool                                 Use of the KEEP Pool              Use of the RECYCLE Pool              Sizing the Default Pool              Sizing the Keep Pool              Sizing the Recycle Pool  Tuning the Three Pools   Chapter 4 - The Undocumented Oracle Parameters   Inside the Undocumented Parameters             Tuning the Database Writer with Undocumented Parameters Hidden Parameters with Inappropriate Default Values Immutable Hidden Parameters Oracle Recovery with _ALLOW_RESETLOGS_CORRUPTION             Procedure   Chapter 5 - Oracle Event Internals   Event Classes The Initialization File Event Settings Example Uses of the EVENT Initialization Parameter             Events at the Session Level Example Uses of the ALTER SESSION Command to Set EVENT Codes Seeing which Events are Set in a Session             Using DBMS_SYSTEM.SET_EV and               DBMS_SYSTEM.READ_EV

Chapter 6 - Tablespace and File Internals Scripts    Monitoring Tablespace Free space and Fragmentation              Monitoring Tablespace Autoextend Settings              Monitoring Tablespace Data Files              Monitoring Tablespace Extent Mapping  Monitoring Rollback Segments              Monitoring Rollback Usage and Statistics              Monitoring Rollback Current Usage              Monitoring Rollback Transaction Size              Monitoring Deferred Rollback Segments  Monitoring Redo Log Activity              Monitoring Redo Log Status              Monitoring Redo Log Switches              Monitoring Redo Statistics  Directory and Library Internals  Monitoring Directories  Monitoring Libraries Chapter 7 - Storage and Object Internal Scripting   Monitoring Ownership, Placement, and Clustering Monitoring Size of Tables Table Statistics Scripts Table Type Internals Table Columns Internals Table Column Statistics Internals Table Key Internals Finding Tables with Chained Rows             Using the ANALYZE Command Partitioned Table Internals Monitoring Partition Statistics Table Sub-partition Internals Monitoring Sub-partition Statistics Nested Table Internals External Table Internals             Cluster Table Internals Monitoring Table Cluster Storage Statistics Monitoring Cluster Statistics Monitoring Cluster Hash Expressions Monitoring Oracle8 Types, Collections, Methods, and Operators             Monitoring Types Monitoring Type Collections Monitoring Type Methods Monitoring Type REFs             Monitoring Operators             Monitoring Dimensions             Monitoring Stored Outlines Monitoring Outline Hints             Monitoring of Materialized Views and Materialized View Logs           Using DBA_ and V$ type Views   Chapter 8 - Index Internals Scripting   Monitoring Index Statistics Monitoring Partitioned Indexes             Function-based Index (FBI) Internals             Domain Index Internals Bitmap Join Index Internals   Chapter 9 - Security Internals Scripts   Table Security Internals Using the V$ and DBA_ Views for Monitoring Users            Monitoring User Setup            Monitoring User Roles            Monitoring User Table and Column Grants            Monitoring Currently Logged-in User Processes Monitoring Profiles Audit Table Monitoring