- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Other titles in the Oracle series:
Oracle9i High Performance Tuning with Statspack (Oracle)by Donald K. Burleson
Synopses & Reviews
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.
Book News Annotation:
Explains how to use the Oracle STATSPACK utility to proactively monitor and tune a database by looking at historical trends and performance patterns. The author progressively walks through tuning the Oracle server environment, the global parameters that affect the Oracle database, individual table and indexes within the database, and individual SQL queries. Modified scripts for reading data from the STATSPACK tables and creating reports are provided.
Annotation c. Book News, Inc., Portland, OR (booknews.com)
STATSPACK was a standing-room only topic at the IOUG-A conference. DBAs can instantly optimise their database and applications with STATSPACK and this resource.
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.
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.
Table of Contents
PART I: Overview of the Method and the Tools
2: Overview of STATSPACK
4: Data Inside the STATSPACK Tables
5: Extending STATSPACK to Collect Server Statistics
7: Tuning the Network Environment
PART III: Tuning the Oracle Database with STATSPACK
10: Tuning Oracle Tables and Indexes
12: Tuning with Oracle Parallel Features
PART IV: Database Reporting with STATSPACK
15: Trend Analysis with STATSPACK