- Series: Oracle Press
- Paperback: 645 pages
- Publisher: McGraw-Hill Education; 1 edition (April 12, 2002)
- Language: English
- ISBN-10: 007222360X
- ISBN-13: 978-0072223606
- Product Dimensions: 7.4 x 1.5 x 9.2 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
- Average Customer Review: 9 customer reviews
- Amazon Best Sellers Rank: #4,549,122 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Oracle9i High-Performance Tuning with STATSPACK 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who viewed this item also viewed
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
- 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.
- 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.
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.
A large portion of the book wastes time on Oracle8i architectures that have become obsolete in Oracle9i. The book concentrates on the creation and usage of a repository for information that Statspack does not natively support, and then goes on to either completely ignore actual tuning methods, or simply gloss over them.
Whats more, the author's method for tuning (stated in the earliest sections of the book) make little sense to me.
WHY ON EARTH WOULD YOU TUNE THE HARDWARE BEFORE YOU TUNE THE SQL?
HOW COULD YOU POSSIBLY KNOW THAT THE HARDWARE INFRASTRUCTURE IS INSUFFICIENT PRIOR TO GETTING EVERY CYCLE OUT OF IT THAT YOU CAN?
1. It wouldn't include information about Oracle 8. This is 9i book; and if I needed 8i advices I would buy a book on 8i (there is one). This way it could be twice as thin (and cheaper ???).
2. Scripts that accompany this book were more acurate, i.e. they are written for 8i and do not cover 9i changes, therefore statistics returned by these scripts is inacurate.
I wish that publisher and the author paid more attention to the quality.
The concepts are presented clearly and elegantly, and the supplemental scripts are very useful. This is a great book to add to your collection that you will actually use.
Could see new ideas, new ways of thinking/implementing. Could recommend to intermediate/advanced DBA as a tuning/statspack bible.