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

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

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


Mike Ault

ISBN:
0-9740716-3-3

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
 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:

 

 

 

 

 

   

 Copyright © 1996 -2016 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