Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



  Tuning Third-party Vendor Oracle Systems
Tuning when you can't touch the code

Mike Ault


80 Pages



Only $12.95


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.

Key Features

* 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


 Using Oracle Resource Plans and Groups

 Creating a Resource Plan
 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:
 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:







 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks