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.
Donald K. Burleson is one of the world's most widely published Database experts with more than 20 years of full-time DBA experience.
He specializes in creating database architectures for very large online databases and he has worked with some of the world's most powerful and complex systems.
A former Adjunct Professor Emeritus, Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress.
Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.
