Oracle9i High-Performance Tuning with STATSPACK [Paperback]

Donald Burleson (Author)

Book Description

ISBN-10: 007222360X | ISBN-13: 978-0072223606 | Publication Date: March 22, 2002 | Edition: 1

Get complete coverage of STATSPACK—Oracle’s powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts you’ll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

Editorial Reviews

From the Back Cover

Take Full Advantage of the Oracle STATSPACK Utility

Make Oracle STATSPACK the backbone of a fail-safe Oracle tuning environment. Officially authorized by Oracle Corporation, Oracle9i High-Performance Tuning with STATSPACK explains how to use this versatile tool to capture, analyze, and report on your database as well as how to monitor, tune, and optimize system performance. Inside, database expert Don Burleson explains everything from installing and configuring STATSPACK for peak performance to performing trend analysis with STATSPACK data. You'll also get ready-to-run scripts throughout the book.

• Extend STATSPACK to collect server statistics into Oracle tables
• Tune the server environment, including the CPU and RAM
• Optimize Oracle Net8 configuration
• Monitor and tune the disk I/O subsystem
• Detect and correct instance performance problems
• Manage Oracle9i RAM allocation with new V$ views
• Tune Oracle tables and indexes
• Locate and tune SQL statements
• Tune with Oracle Parallel Query and Oracle parallel DML
• Tune Oracle Real Application Clusters (RAC)

About the Author

Don Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (O’Reilly), High-Performance Oracle8 Tuning, High-Performance Oracle Data Warehousing, High-Performance Oracle Database Applications (Coriolis) and Oracle8 Tuning, German Edition (Sybex). Don has taught more than 100 University courses and regularly conducts in-house Oracle training.

Product Details

• Paperback: 645 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 22, 2002)
• Language: English
• ISBN-10: 007222360X
• ISBN-13: 978-0072223606
• Product Dimensions: 9 x 7.3 x 1.7 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (13 customer reviews)
• Amazon Best Sellers Rank: #1,643,404 in Books (See Top 100 in Books)

More About the Author

Donald K. Burleson is one of the world's most widely published 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 Emeritus, Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress.

Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

4.0 out of 5 stars Robust book with a good ideas, January 13, 2004

By 

java_rw (Santa Clara, CA United States) - See all my reviews

This review is from: Oracle9i High-Performance Tuning with STATSPACK (Paperback)

Statspack is a Godsend tool from Oracle.

This and the previous edition of the book provide DBAs with an excellent introduction into understanding statspack internal tables and great ideas on how to integrate critically important OS statistics into the statspack data gathering process.

Using statspack daily, I found this book and Performance Explorer-i / Statspack program (found it on internet - made by dbainfopower) to be invaluable tools that extend statspack capabilities and help to resolve complex performance problems.

5 of 5 people found the following review helpful:

3.0 out of 5 stars Worth the time and $, June 11, 2004

By A Customer

This review is from: Oracle9i High-Performance Tuning with STATSPACK (Paperback)

I got more than my time and $ worth. It was a good guide to for getting started with Statspack. However, it looks like they rushed this one to market. The book needs another thorough edit. Not all the scripts in the book are in the download. Most of the scripts have at least one problem. Some paragraphs right next to each other seem to contradict each other. However, if you're experienced with oracle and just need to add statspack to your bag of tricks, it's worth it.

5 of 5 people found the following review helpful:

4.0 out of 5 stars Pretty good, but a little misleading, June 14, 2003

By 

"adrianomp" (Brazil) - See all my reviews

This review is from: Oracle9i High-Performance Tuning with STATSPACK (Paperback)

The book is pretty good, it covers some basic topics on implementing STATSPACK and using it for monitoring Oracle. However, it was a little misleading and not too much organized sometimes.

The best:
- Straight, practical and full of scripts/examples
- Gives some tips and explains some Oracle performance issues
- Covers not only database, but network and OS common performance problems (directed to Unix)
- Covers not only 9i, but previous versions too.
- Gives a good guideline on proactive tuning.

The worst:
- It's misleading sometimes. The book covers different Oracle versions, but not always we know if an example applies only to 9i or previous versions. May cause confusion on beginners/intermediate DBA's who hadn't contact with previous Oracle versions
- Some typos and errors on the scripts and the text (9i uses PCTFREE even on Automatic segment management)
- I was expecting a deeper explanation on STATSPACK tables. The book relies only on a few (the most important, ok, but it's not everything). I missed a better approach on other performance issues like checkpointing, log switches, latches and waits in general.

Finally, it is a very good book and worthy buying, but could be even better.