Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 Catalog
 Oracle Books
 Oracle Software
 Job Interview
 eBooks
 SQL Server Books
 News
 Oracle Scripts
 Oracle Tuning Book
 Remote DBA
 Oracle Tuning
 

  

 

Rampant Oracle In-Focus Series

 

 

Mike Ault’s
Oracle Internals Monitoring
& Tuning Scripts

Advanced internals & OCP certification insights for the master DBA


Mike Ault

ISBN 0-9727513-8-6 
Retail Price $34.95 / £20.75  

Order now and get 30% off the retail price!

You also receive online access to the code depot!

Only $24.95

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.

 

About the Author:

 

Mike Ault

  Mike Ault is one of the leading names in Oracle technology.  The author of 20 books and hundreds of articles in national publications, Mike was the first popular Oracle author with his landmark book "Oracle7 Administration and Management".  Mike also wrote several of the "Exam Cram" books, and enjoys a reputation as a leading author and Oracle consultant.

Mike started working with computers in 1979 right out of a stint in the Nuclear Navy. He began working with Oracle in 1990 and has since become a World Renowned Oracle expert (in the words of his publisher anyway!) Mike has written 14 Oracle related books, dozens of articles, and has presented at conferences in Europe and the USA. Mike has two wonderful daughters and is kept out of trouble by his wife of 29 years, Susan.

 

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

 

 

 

 

    P. O. Box 511
Kittrell, NC, 27544