Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook. With decades of experience using Oracle, Mike Ault shares secrets for Oracle data warehouse management. This fantastic eBook discusses how to tune vendor applications where you cannot touch the source code. These techniques apply to Oracle SAP tuning, Oracle Peoplesoft Tuning and Oracle applications tuning. Topics include optimizer plan stability, stored outlines, and SGA tuning techniques.

* Learn Database Buffer Tuning. * Understand Tuning Checkpoints. * Use the Default Pool. * Manage Multiple Buffer Pools in Oracle. * Use Oracle Resource Plans and Groups.

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

Table of Contents:

 

Optimizing Oracle Internals    Database Buffer Tuning  Database Writer Tuning  Shared Pool Tuning  What is the shared pool?  Monitoring and Tuning the Shared Pool  Putting it All In Perspective  What to Pin  The Shared Pool and MTS  Large Pool Sizing  A Matter Of Hashing  Monitoring Library and Data Dictionary Caches   In Summary  Tuning Checkpoints  Tuning Redo Logs  Redo Log Sizing  Tuning Rollback Segments  Tuning Oracle Sorts    Optimizer Modes Tuning the Multi-part Oracle Buffer Cache  Use of the Default Pool  Use of The KEEP Pool  Use of the RECYCLE Pool  Tuning the Three Pools  Adding Resources   Tuning Tables and Indexes  Table Rebuilds  Rebuilding Indexes  Adjusting Index Cost in Oracle  Bitmapped Index Usage*  Function Based Indexes  Reverse Key Indexes  Index Organized Tables  Partitioned Tables and Indexes  Partitioned Indexes  Parallel Query  Oracle Enhanced Parallel DML

Managing Multiple Buffer Pools in Oracle  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   Using Outlines in Oracle  Creation of a OUTLINE object  Altering a OUTLINE  Dropping an OUTLINE  Use of the OUTLN_PKG To Manage SQL Stored Outlines  DROP_UNUSED  DROP_BY_CAT  UPDATE_BY_CAT    Using Oracle Resource Plans and Groups  Creating a Resource Plan  DBMS_RESOURCE_MANAGER Package  DBMS_RESOURCE_MANGER Procedure Syntax  Syntax for the CREATE_PLAN Procedure:  Syntax for the UPDATE_PLAN Procedure:  Syntax for the DELETE_PLAN Procedure:  Syntax for the DELETE_PLAN Procedure:  Syntax for the CREATE_RESOURCE_GROUP Procedure:  Syntax for the UPDATE_RESOURCE_GROUP Procedure:  Syntax for the DELTE_RESOURCE_GROUP Procedure:  Syntax for the CREATE_PLAN_DIRECTIVE Procedure:  Syntax for the UPDATE_PLAN_DIRECTIVE Procedure:  Syntax for the DELETE_PLAN_DIRECTIVE Procedure:  Syntax for CREATE_PENDING_AREA Procedure:  Syntax of the VALIDATE_PENDING_AREA Procedure:  Syntax of the CLEAR_PENDING_AREA Procedure:  Syntax of the SUBMIT_PENDING_AREA Procedure:  Syntax of the SET_INITIAL_CONSUMER_GROUP Procedure:  Syntax of the SWITCH_CONSUMER_GROUP_FOR_SESS Procedure:  Syntax of the SWITCH_CONSUMER_GROUP_FOR_USER Procedure:  DBMS_RESOURCE_MANAGER_PRIVS Package  DBMS_RESOURCE_MANGER_PRIVS Procedure Syntax  Syntax for the GRANT_SYSTEM_PRIVILEGE Procedure:  Syntax for the REVOKE_SYSTEM_PRIVILGE Procedure:  Syntax of the GRANT_SWITCH_CONSUMER_GROUP Procedure:  Syntax of the REVOKE_SWITCH_CONSUMER_GROUP Procedure: