Oracle High Performance Tuning for 9i and 10g

Rating:
Summary: Great book!
Review: Database performance usually is a matter of concern to DBAs and programmers alike. This book covers nicely the issue from all points of view, and provides answers and "things to look at" which most probably will help you sorting out a performance problem.

It is well written, helpful and very easy to follow. A must.

Rating:
Summary: Great book!
Review: Database performance usually is a matter of concern to DBAs and programmers alike. This book covers nicely the issue from all points of view, and provides answers and "things to look at" which most probably will help you sorting out a performance problem.

It is well written, helpful and very easy to follow. A must.

Rating:
Summary: a once over lightly of many topics not for knowledgeable dba
Review: For lightweight or beginning oracle dba's this book may be useful. It is way too ambitious in what it attempts to cover and is not suitable for anyone that has much of a clue already what is going on in oracle.

Particularly pathetic is the over reliance of the author in testing performance of an application he apparently patched together, running on a pentium II windows machine with 128 meg of ram. Unfortunately he bases all his testing results of this machine. A semi decent sun or hp workstation can be had for under 1000 dollars ... even a more recent intel box running linux with a reasonable amount of memory would be a much better basis.

Rating:
Summary: Oracle High Performance Tuning for 9i and 10g
Review: Great examples, good explanations, worth the investment.

As an author of Oracle books myself, I am hard to please. Mr. Powell has earned my respect with this book. He uses easy to follow examples and explanations throughout. At the same time, he does not over-simplify a complex topic. His work is based on solid research and experience in the field.

Rating:
Summary: Excellent Book for developers and DBA
Review: I am so glad I bought this book. It covers all the aspect of Oracle tuning very well, like (explains Data Modelling, SQl Tuning, Instance tuning and Network tuning).
The author has done very well in explaining the concepts and working of Oracle in very good diagrams and very simple explanation.
The book also covers how to design the data when to do normalization and when not to, in a very practical manner. Which we as developer/designer may overlook at times.
The hints/tip given when to do things in OLTP and Data Warehouse world is extremely useful.
The tips on which oracle feature is either new/desupported/deprecated in future release is very helpful.
Also the examples covered during sql tuning are very good.
Overall I highly recommend this book, it is highly readable, very good explanation and hints for tuning and worth having in your library.


Rating:
Summary: Good book!
Review: It is a good book. From it, I learned more knowledge deeply.
Hope more people benefited from this book!

Rating:
Summary: NICELY DONE!
Review: 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.