Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance

Description:

Oracle9i has become one of the world’s most complex databases, and this book is for the senior Oracle DBA who needs to automate the complex mechanisms that govern the RAM memory regions of any Oracle database.

The dynamic memory features of Oracle9i make it possible to create a self-tuning database.  This exciting book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs.

Focusing on proactive tuning and scripting, this books show you how to collect historical data and use it to develop signatures for all memory areas.  Using these metrics, you can develop scripts that will anticipate and correct upcoming SGA performance problems.

 

Table of Contents:

Chapter 1 - Overview of the Oracle9i SGA Regions    
RAM Allocation at Oracle Instance Startup      
Oracle SGA parameters          
RAM and the Oracle Server    
RAM on IBM-AIX UNIX      
RAM in Linux  
RAM on MS-Windows           
RAM used by Oracle Connections       

Chapter 2 - Oracle9i Self-tuning basics
Monitoring the data buffers      
Oracle9i Sorting          
The v$sysstat View      
The v$pgastat View     
The v$process view     
The v$workarea view  

Chapter 3 - Oracle9i Data Buffer Internals       
Tuning the Oracle9i data buffer Pools   
Data Block Caching in the SGA           
Full table Caching in Oracle9i   
The Data Buffer Hit Ratio        
Data Buffer Monitoring
Allocating Oracle9i data buffer caches  
Internals of the Oracle Data Buffers      
Finding Hot Blocks inside the Oracle Data Buffers        
Full Data Caching Techniques  
Data Buffer Monitoring with STATSPACK     
Understand the KEEP and RECYCLE Pools   
STATSPACK Tables and KEEP Pool Data    
Advanced KEEP Pool Candidate Identification
Advanced RECYCLE Pool Tuning      
Large Blocks and Oracle Indexes        
Maximizing Oracle9i block space usage           
Summary of block size rules     
Mapping data blocks to data buffers     

Chapter 4 - Proactive SGA Reconfiguration     
Scheduling SGA reconfiguration           
Trend-based Oracle Reconfiguration    
Plotting the Data Buffer Hit Ratio by Hour of the Day   
Approaches to Self-tuning Oracle9i Databases