View Larger Image	Donald Burleson Rampant TechPress, Paperback, Published August 2003, 139 pages, ISBN 0972751327
	List Price: $16.95 Our Price: $10.95 You Save: $6.00 (35% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Oracle9i High-Performance Tuning with STATSPACK; Donald K. Burleson, $35.95, 40% Off!
• Mike Ault's Oracle Internals Monitoring & Tuning Scripts; Mike Ault, $21.95, 37% Off!
• Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
• Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader, oradebug, tkprof, & More (Oracle In-Focusseries); Dave Moore, et al, $17.50, 37% Off!

• Databases : Oracle

• Rampant TechPress

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.

Key Features:

• Presents a method for monitoring important SGA metrics over long time periods.

• Lists the commands to modify the Oracle9i SGA areas, including pga_aggregate_target, shared_pool and db_cache_size.

• Describes how to recognize patterns in RAM usage.

• Explores the use of the free STATSPACK utility to monitor and collect SGA information.

• Offers sample scripts for automating SGA tuning.

• Provides access to an online code deport, full of interesting Oracle scripts.
  

About the Author:

Don Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.   A former Adjunct Professor, Don Burleson has written 32 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

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 

Oct 25, 2003     Christopher W. Lawson from Dublin, CA
Mysteries Revealed
This book is another insightful guide from the master of Oracle database tuning, Donald Burleson. Readers will no doubt recall that Mr. Burleson wrote the Oracle best sellers, "Oracle High-Performance SQL Tuning" and Oracle High-Performance Tuning with Statspack." Mr. Burleson brings the same level of expertise to this new series of books published by "Rampant Techpress."

This volume unravels the mysteries of the various database caches and pools in the 9i database. Are you confused about the different pools and database caches that have been introduced in recent years? Do you know what the difference is between the "Keep Pool" and the "Recycle Pool" ? Okay, how about this: How many buffer caches are there-7 or 8 ? Where should you put your indexes-in the cache with the largest block size, or the smallest?

I confess that I have found it difficult to keep up with the myriad cache and pool changes that Oracle has introduced in recent years. I suspect that other DBAs also find it challenging. These issues are all addressed in this book, with extensive examples and scripts, so that readers can try it for themselves. There are a total of 29 useful scripts that are provided with this book (I successfully downloaded them from the Rampant web site).

I found the section, "Internals of the Oracle Data Buffers" particular interesting. It explains the difference between the pre-Oracle 9i buffering system and the new "touch count" method used in 9i. In this section, the script "Buf_Blocks.sql" is really amazing. It lists in tabular format the exact distribution of objects in the data buffers, sorted by buffer pool. Using this script, you can see which pool your indexes or tables have been assigned.

Beware! This book isn't filled with "fluff" or some theoretical treatises dreamed up by academians. This is a book BY AND FOR PRACTICING DBAS. The focus in the book is on PROACTIVELY improving database performance. If you are a "Hands on" DBA interested in getting the best performance from your system, then you will find this book very helpful.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account