Oracle Tuning: The Definitive Reference

Donald K. Burleson, Alexey B. Danchenkov

Rampant TechPress, Apr 21, 2006 - Computers - 960 pages

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

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.

About the author

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

• Title: Oracle Tuning: The Definitive Reference; Volume 24 of Oracle In-Focus
• Authors: Donald K. Burleson, Alexey B. Danchenkov
• Editor: Donald K. Burleson
• Edition: 2, illustrated
• Publisher: Rampant TechPress, 2006
• ISBN: 0974448621, 9780974448626
• Length: 960 pages
• Subjects: Computers / Database Management / General; Computers / General