Oracle Tuning: The Definitive Reference

Front Cover
Rampant TechPress, Feb 1, 2006 - Computers - 960 pages
8 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  - Krishnac949 - Goodreads

It's Good Read full review

Review: Oracle Tuning: The Definitive Reference

User Review  - Anjul Sahu - Goodreads

Good Book...Keep reading every time you are free. There is so much to get from this book for Oracle professionals. Read full review

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