Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
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.