Features
- Cover Type: Paperback with 674 pages
- Published by: McGraw-Hill Companies
- Edition: 1st Edition April 20, 2001
- Written in: English
- ISBN 10 Number: 0072133783
- ISBN 13 Number: 978-0072133783
-
Book Dimensions:
9.1 x 7.4 x 1.6 inches
- Weighs: 3.1 pounds
Book 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.
Book Info
(Oracle Press/Osborne) Handbook for Oracle STATSPACK users, to making informed performance and tuning decisions for a system, based on data gathered with the utility. Shows how to perform trend analyses, locate and tune SQL statements, tune the server environment, including the CPU and RAM, and detect and correct performance problems. Softcover.
Reader Reviews
It's quite difficult to write a book about statistical analysis, UNIX server tuning and Oracle tuning. What's very difficult is to have a general method for several UNIX flavours (and NT, of course) and Oracle versions. Generally speaking, this book exposes basic and advanced techniques for server and Oracle tuning. What is very interesting, is the trend-analysis approach the author uses to show statistical performance information. Using this approach, you can make a better capacity planning for your database. With this book, I realized there was no reason for still wasting my time analyzing UTLBSTAT/UTLESTAT reports, wich cann't provide me with any time-based information and a limited scope of statistical information. Another good point, this book helps you to make extensions for the STATSPACK code. For example, it includes several scripts about how to collect and analyze server performance statistical information (like VMSTAT, SAR, etc). Regarding this point, it's advisable you check too the server provider tuning manuals (like Compaq, Sun, HP, IBM, etc) to confirm any performance recomendation. For Unix servers and complex tuning, take a look for Ahmed Alomari-Oracle8 and Unix tuning, wich is very much deep and precise.
Comment | |
(Report this)