Top positive review
11 people found this helpful
on January 8, 2004
This is an extensive, even scholarly, book by Mr. Powell. He has obviously spent a great deal of effort to explain clearly and concisely some of the most important aspects of Oracle performance tuning.
Some areas that I found especially interesting were his explanations of the various lock mechanisms in the Oracle engine. The book is also very extensively illustrated with examples of execution plans, and many SQL examples. Another area of great use is the explanation of Partitioning-an area that most of us find very confusing.
Mr Powell wisely points out the advisability of developers getting the design right in the first place-preventative medicine, as it were.
The book is also interspersed with explanations of 10g additions. For instance, he shows the improvements to the Wait Event interface starting with 10g. Toward the end of the book, Gavin illustrates how to use the interesting utility Statspack.
All in all, a very nice exposition of a very tough subject.