|
|
|
Book ReviewsOptimizing Oracle Performance |
|
|
Book: Optimizing Oracle Performance
Written by: Cary Millsap |
Publisher: O'Reilly
Average Customer Rating: 4.5 / 5
|
|
Uncommon Sense Rating:
5 / 5
Are you really reading this review because you haven't read this yet? Maybe, like me, you are just gloating. This is a once-in-a-decade read.
It went like this. Read the book. Had the epiphany. Then, as instructed read "The Goal". Epiphany II.
The book presents an optimization method, derived from "first principles". The method is exemplified in sufficient detail (albeit with simplifications) for the reader to implement.
Perhaps most importantly, it is presented in a manner that stimulates the reader on to further inquiry. With a little imagination (and this book does enourage you to use your imagination) the underlying philosophy can be extended to just about any other task you find yourself doing in the data centre.
Lucky for us that the target audience is restricted to those people interested in optimizing Oracle performance or the cat would really be out of the bag.
Must Have for those who tune Oracle Databases Rating:
5 / 5
This book delivers on its promise to open up a new world of analysis and tuning to most DBAs. The concepts, calculations, and methods it provides are excellent. As an experienced tuning consultant I had used some of these methods in the past but this book brings them all together.
The book is written in a style which is enjoyable, scattered through with "war stories" and experiences which illustrate good points.
This book is not just another script book. The author not only shows you how to tune using his method but also explains why that method works. There are complex calculations included in the descriptions but it is not necessary to know higher math to use this process. No matter what method you use for tuning SQL and Oracle instances, there is material in this book which will enhance your understanding and your tuning toolkit.
Outstanding coverage of extended sql trace Rating:
4 / 5
I found Cary's book outstanding.
1. Coverage on generating and understanding extended sql trace is excellent.
2. One of the very few book on Oracle tuning, which deals with a "methodology". I have read several books before this on optimizing Oracle performance and none explains any methodology. This book instead of diving straight into v$ view and statspack data, first makes a ground of what approach should be taken. So its like, what needs to be done and then how to do that.
I find this book incredibly useful.
Thanks
bipul
|
|
|
|
|
|
|
|
|
|