The ADDM is a diagnostic engine built right into the database kernel—it is a rule-based expert system that encapsulates decades of Oracle's performancetuning expertise. What is interesting is that the Database Control is actually an attempt at what appears to be an expert system for automated performance tuning of an Oracle database.
This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. Every Oracle professional would like to be thought of as a performance tuning expert but it is truly all about real-world experience. There are no shortcuts and no training that will make it happen instantly.
Slow systems are the bane This chapter provides an overview of Exadata performance tuning , combining the general principles of Oracle Database tuning with the Exadataspecific technologies covered in detail elsewhere in this book. Written in a clear and engaging style, this book explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork.
Understand the key components of a tuning methodology Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.
The price of this essential book Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a
0コメント