- 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: 12 customer reviews
- Amazon Best Sellers Rank: #4,381,776 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.
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.
1. no mention of Windows anywhere. only covers UNIX, no mention of this in the blurbs
2. Oracle 8i (and even 8.05!) take up more pages than 9i. It's rarely clear where 9i info starts. An obvious copy+paste job from previous editions. And this despite the title of the book.
3. the author spews scripts everywhere. there should be a table of contents for the scripts. it's practically impossible to figure out what scripts there are and what they do. Possibly really lazy or inexperienced DBAs would be interested in all these scripts but most dbas will probably live without them.
4. author promises to provide "extensions" to statspack tables for trend analysis and he makes it sound like he will present a clever way to store snapshot data between reboots the way Capacity Planner does, but it turns out all that all he demonstrates is how to create tables for data collected by UNIX operating system utilities. It is a very misleading description.
1. decent explanations of basic tuning concepts. But again this is copy+pasted straight from a tuning book. I bought this book for info about statspack not tuning 101!
2. decent diagrams of statspack tables but nothing that can't be found on metalink.
I returned this book. It's shovel-ware, plain and simple. The author worked very hard to bloat the size up to 600+ pages to rationalize a $40+ price tag for the publisher. How can he take himself seriously? Or i wonder if the author actually believes this is a well-organized book to be proud of...in which case his mind must be like a tangle of knotted strings.
Could see new ideas, new ways of thinking/implementing. Could recommend to intermediate/advanced DBA as a tuning/statspack bible.
- 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.
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.
Most recent customer reviews
This and the previous edition of the book provide DBAs with an excellent introduction into understanding statspack internal tables...Read more