Reading rather pleasant (no unnecessary jargon, explanations sometimes of great clarity as SQL Plan Management) but we must recognize that this work is far short of my expectations. Worse, there is no way to match the ambitions they set up.
According to the subtitle, this is to "optimize production databases."
And in the objectives listed on page 12: "It provides detailed work methods, guides the DBA concretely through many examples ... He also wants a precious memory aid for DBA ..."
My first fundamental complaint is that no methodology is provided. Faced with a performance problem, where to start, what steps to take? How to ensure that the problem is well within the database? This is not the book that will teach you.
My second criticism equally fundamental, is that this work is generally very shallow, sometimes shamefully superficial, despite its 500 pages good weight.
Many fundamental issues are hardly touched, for example:
- Parallelism
- How to read an implementation plan?
- How to exploit a report AWR?
I do not feel any benefit from the feedback, but to read basic information, which give the impression to remain permanently in the preamble, and never get into the thick of it.
Furthermore, no explanatory diagram is never given, then they would, in many cases, most welcome to clarify a technical detail, or provide an overview of a complex process.
Facing these unacceptable defects, I can not recommend such a book, which clearly does not hold a candle to the "Troubleshooting Oracle Performance" Christian Antognini, the "Oracle Performance tuning tips & Techniques" Richard Niemiec, or "Oracle Performance Survival Guide" by Guy Harrison, unfortunately all in English.