The Art and Science of Oracle Performance Tuning

From the Publisher: Complete and approachable guide to tuning best practice. For novice to intermediate Oracle DBAs and developers.Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the author's long experience working with Oracle, the book uses a five-step model to help identify and isolate the cause of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success. The Art and Science of Oracle Performance Tuning shows you: A proven process for performance tuning How to objectively categorize the problem The human and business aspects of tuning as well as the technical know-how How to trace problems to their root cause Analyzing the cost of SQL statements Gathering statistics - achieving quantifiable results Devising and testing a solution Case studies throughout illustrate key points