Oracle High-Performance Tuning with STATSPACK (Paperback)

by Donald K. Burleson (Author), Don Burleson (Author) "Oracle tuning has always been the most difficult area of Oracle database management..." (more)
Key Phrases: data buffer hit ratio, column mydate, idx stats, Oracle Parallel Server, Name Null, Mon Jan (more...)

Editorial Reviews

Product Description
From the official Oracle Press comes a comprehensive guide to using STATSPACK--Oracle's powerful tuning utility. Written by a database management expert, this authoritative resource explains how to collect, interpret, and correct Oracle performance problems using STATSPACK.

From the Back Cover
Monitor and tune your Oracle database using STATSPACK

Use the Oracle STATSPACK utility as the foundation for a comprehensive Oracle tuning environment. Officially authorized by Oracle Corporation, Oracle High-Performance Tuning with STATSPACK explains how to use this powerful tool to diagnose--and optimize--system performance. You'll get full details on server, network, and disk tuning, as well as instance, object, and SQL tuning. Plus, the book contains ready-to-use STATSPACK scripts throughout. Make informed performance and tuning decisions for your system based on the data you collect with Oracle STATSPACK.
*Install and configure STATSPACK for peak performance
*Extend STATSPACK to capture server statistics
*Tune the server environment, including the CPU and RAM
*Configure your Oracle database for better network performance
*Monitor and tune the disk I/O subsystem
*Detect and correct instance performance problems
*Tune Oracle database tables and indexes
*Locate and tune SQL statements
*Tune with Oracle parallel query and parallel DML
*Perform trend analysis with STATSPACK data

See all Editorial Reviews

Product Details

• Paperback: 674 pages
• Publisher: McGraw-Hill Companies; 1st edition (April 20, 2001)
• Language: English
• ISBN-10: 0072133783
• ISBN-13: 978-0072133783
• Product Dimensions: 9.1 x 7.4 x 1.6 inches
• Shipping Weight: 3.1 pounds
• Average Customer Review: 3.7 out of 5 stars See all reviews (14 customer reviews)
• Amazon.com Sales Rank: #1,345,001 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #33 in

  Books > Computers & Internet > Databases > Oracle > Tuning

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

3.0 out of 5 stars About what I expected, August 13, 2001

By	Jeffrey J. Hunter (Wilton, CT United States) - See all my reviews (REAL NAME)

This book is a generalized look at tuning performance problems with Oracle's Statspack product. The majority of the examples and scripts are based on the Unix OS. If you are looking for a book on tuning Oracle on Unix, this is not it....

Beginning DBA's will get a fair amount out of this book. While I disagree with the author's methodology to solving performance problems, it would be a roundabout method for Novice DBA's to tune their systems. Experienced DBA's will find little new information in this book.

While Don does touch on that statspack package, most of the information comes from his custom scripts. He references the default statspack report very few times and never goes through a comprehensive step-by-step explanation of what everything means....

10 of 11 people found the following review helpful:

2.0 out of 5 stars Not what I expected, October 4, 2001

By	Oracle DBA (TX United States) - See all my reviews

I was expecting this book to describe and help me decipher the statspack information to help me tune the database. Author focuses more on customizing statspack and running scripts against the statspack tables. Anyways, not what I needed. I'd like to know how to decipher Oracle's cryptic information.

5 of 6 people found the following review helpful:

5.0 out of 5 stars Get to the heart of your Tuning issues., June 15, 2001

By	Jame Gaston (Rochester, NY USA) - See all my reviews

"High-Performance Tuning with Statspack" establishes a baseline understanding of tuning and addresses each topic in an easy to understand manor, with illustrated examples of how to implement the concept. There are commands and tools to identify network and system performance slow downs, like top, iostats and vmstat. Each is documented how to use and what the output really means. Examples throughout the book include the commands for different hardware, like Solaris, HP and AIX. The one thing I found most useful was the methodical way to identify a performance issue as a network, system, rdbms or sql code issue. This book is filled with tips and tricks, sql code, and other useful commands that help you get to the heart of the your tuning issues.