Rittman Mead - Delivered Intelligence

This
isn’t one I’ve come across before.

"Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning"
by Kirtikumar Deshpande and K. Gopalakrishnan is

described by Amazon as "Troubleshoot, tune, and optimize your Oracle
database efficiently and successfully every time. This book explains how to take
full advantage of the revolutionary Oracle Wait Interface to quickly
pinpoint–and solve–core problems and bottlenecks, and increase productivity
exponentially.". There’s some

good reader reviews on Amazon as well, including

"I recently attended a local OUG Meeting in which Richmond gave a
presentation on the efficient use of the Oracle Wait Interface to diagnose and
solve performance problems. His presentation and philosopy corroborated
another source that I had read "Performance Tuning 101" Unfortunately, I
didn’t win one of the three copies that he was giving away at the meeting.
Instead, I went straight back to the office to order this book. It is
everything I expected and more. I particularly appreciate chapter 4 in which
the authors provide step by step instruction on how to create your own tool
for monitoring and collecting wait interface data. I just implemented this new
tool in a production environment and have already been able to diagnose some
potential application "issues". This book rocks."

and

"This is the first book i have come across that has accurate and tuning
oriented discussions on simple but key topics like ‘db file sequential read’
and other very common wait events. Once you read this, you do not need to look
further to connect this information with something else! this is where you
stop digging and start tuning !

If there is one external book that has the best discussion on Locks and
Latches (other than the concepts manual!), it has to be this one. Tuning
latches and enqueues, contention/latency based tuning is very well explained.

With excellent queries and helpful examples, this book is full of information
and tends to provide a lot of food for thought even for the experienced DBAs.
The X$ definitions used are very useful for someone who wants to dig and dig
deep…"

Anyone read it? How does it compare with

Oracle 101 Performance Tuning,

Oracle9i High-performance Tuning with STATSPACK and

Optimizing Oracle Performance? Leave a comment if you’ve come across it.

Posted in Uncategorized |