Oracle Tuning: The Definitive Reference

Front Cover
Rampant TechPress, Feb 1, 2006 - Computers - 960 pages
10 Reviews
Oracle 10g has become the most complex database ever created and Oracle tuning has become increasingly complex. This book provides a complete step-by-step approach for holistic Oracle tuning and it is the accumulated knowledge from tuning thousands of Oracle databases. Incorporating the principles of artificial intelligence, Oracle10g has developed a sophisticated mechanism for capturing and tracking database performance over time periods. This new complexity has introduced dozens of new v$ and DBA views, plus dozens of Automatic Workload Repository (AWR) tables. The AWR and its interaction with the Automatic Database Diagnostic Monitor (ADDM) is a revolution in database tuning. By understanding the internal workings of the AWR tables, the senior DBA can develop time-series tuning models to predict upcoming outages and dynamically change the instance to accommodate the impending resource changes. This is not a book for beginners. Targeted at the senior Oracle DBA, this book dives deep into the internals of the v$ views, the AWR table structures and the new DBA history views. Packed with ready-to-run scripts, you can quickly monitor and identify the most challenging performance issues.

What people are saying - Write a review

User ratings

5 stars
4 stars
3 stars
2 stars
1 star

Review: Oracle Tuning: The Definitive Reference

User Review  - Goodreads

this is a great book. Read full review

Review: Oracle Tuning: The Definitive Reference

User Review  - Goodreads

It's Good Read full review

Other editions - View all

About the author (2006)

Alexey B. Danchenkov holds a master's degree in computer science from St. Petersburg State University of Aerospace Instrumentation He started work as an Oracle database administrator at Leaves Inc and worked for several years as a principal Oracle DBA at a large telecommunications company, where he managed very large database and billing systems. Alexey is also the creator of the STATSPACK Viewer software, a popular Oracle graphics package. Donald K. Burleson is one of the world’s top Oracle 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, Don Burleson has written 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Bibliographic information