Publisher's Synopsis
In today's Internet-centric economy, quick and consistent response time is incredibly important. Statspack allows the collection automation, storage and viewing of performance data. Plus, it makes the collection of performance data easy to set up. This tuning utility is becoming very popular. Administrators that run Statspack need detailed techniques for using the information to tune their Oracle databases. This book combines important tuning techniques with ready-to-use Statspack utility scripts.;The information in this text can be used for more than standard performance tuning. Readers will also learn how to use Statspack for capturing trend data - especially useful for capacity planning. The guide contains advanced tuning concepts and proven methods to identify hidden performance problems. It covers all of the important areas of Oracle tuning and includes comprehensive Statspack coverage. Also provided are ready-to-run scripts that gather tuning information on an Oracle database. In addition to the one-time correction of performance bottlenecks, the reader will learn to use Statspack to collect ongoing performance information for alert mechanisms, trend analysis and long-term resource planning.
