Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Oracle Press)


Product Description
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.Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Oracle Press) Review
if you're into the whole wait event thang, get this book. This is a great resource. Very interesting reading! Chapter 4 presents an event data collector (page 86: Sampling for performance data using pl/sql procedure), a very nice idea. The logoff trigger discussed in the same chapter is nice too. Chapter 5 gives a good overview of some of the most important I/O related wait events. Chapter 6, Locks and latches. Chapter 7, latency related wait events. And then there's tons more, look inside the book and see what I mean...All in all, this is one of the best Oracle books of the past six months. My other favorite would be 'Oracle Insights' from Oaktable press.
I've implemented the data collector mentioned inchapter 4 to diagnose some performance problems. If you're interested, you can download the code for free from my website, www rhdba dot com. Look under Oracle SQL Scripts -> Event data collector.
Other must have books:
- Tom Kyte's 'Expert one-on-one' and 'Effective Oracle by Design'
- Cary Millsap and Jeff Holt 'Optimizing Oracle Performance'
- Oaktable press 'Oracle Insights'
Most of the consumer Reviews tell that the "Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Oracle Press)" are high quality item. You can read each testimony from consumers to find out cons and pros from Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Oracle Press) ...

No comments:
Post a Comment