Publisher's Synopsis
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 the reader how to approach problems, get the information needed from Oracle, and follow the process through to success.;"The Art and Science of Oracle Performance Tuning" shows the reader: 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; and case studies throughout illustrate key points.
