Shop now Shop now Shop All Amazon Fashion Up to 70% off Fashion Cloud Drive Photos Shop Amazon Fire TV Shop now Shop Fire HD 6 Shop Kindle Voyage Shop now Shop Now Shop now
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Oracle Wait Interface: A ... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by owlsmart_usa
Condition: Used: Good
Comment: Good clean copy with no missing pages might be an ex library copy; may contain marginal notes and or highlighting
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Oracle Press) Paperback – 1 Jul 2004

2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£22.45 £2.99
£42.99 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Special Offers and Product Promotions

  • Save £20 on with the aqua Classic card. Get an initial credit line of £250-£1,200 and build your credit rating. Representative 32.9% APR (variable). Subject to term and conditions. Learn more.

Product details

  • Paperback: 384 pages
  • Publisher: McGraw-Hill Osborne (1 July 2004)
  • Language: English
  • ISBN-10: 007222729X
  • ISBN-13: 978-0072227291
  • Product Dimensions: 18.3 x 2 x 22.9 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 456,594 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Identify and Resolve System Bottlenecks Quickly

Troubleshoot, diagnose, and optimize your Oracle database efficiently and successfully every time. This exclusive Oracle Press guide explains how to take full advantage of the revolutionary Oracle Wait Interface (OWI) to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially. Get extensive details on all the OWI features, including the wait event views, their applications, and the extended SQL trace file. This invaluable resource will help you maximize the most advanced diagnostics tool available and minimize processing time.

  • Identify performance problems using wait event statistics
  • Monitor session-level wait events and collect historical data for root cause analysis
  • Interpret common I/O-related wait events
  • Diagnose and solve problems related to locking and serialization
  • Analyze latency-related wait events
  • Identify and resolve bottlenecks in the Oracle Real Application Clusters environment
  • Learn about the Oracle Database 10g revolutionary approach to performance diagnostics and tuning

About the Author

Richmond Shee (Olathe, KS) is a Senior Database Architect for Sprint Corporation, with more than 14 years of RDBMS experience, including 8 years working with Oracle databases. Richmond has also spent 2 years working with the Oracle Core Technology Group. He oversees the Performance Consultation Team, mentors DBAs and helps set the direction for implementing Oracle RDBMS technology throughout the company. Richmond leads the tuning efforts on all of Sprint’s most critical databases. Among his many accomplishments, he pioneered the use of the Oracle Wait Interface at Sprint. He also invented a patent-pending wait-based tuning tool. This tool is being deployed throughout Sprint Corporation & Sprint PCS. He frequently speaks at the Kansas City OUG, contributes to the Oracle-L listserver, and volunteers his time by mentoring DBAs in the Kansas City area.

Kirtikumar Deshpande (Kirti Deshpande) has been working in the Information Technology field for over 20 years, including more than seven years as an Oracle DBA. Although a Biomedical Engineer by profession, he has chosen Information Technology as his career. He currently works with Verizon Information Services as a Senior Oracle Database Administrator and is a frequent contributor on the Oracle-L and LazyDBA listservers. He can be reached at

K. Gopalakrishnan (Gopal) is an award-winning coauthor ("Oracle Author of the Year 2005"-Oracle Magazine) of Oracle Wait Interface (Oracle Press). He also authored Oracle Database 10g Real Application Clusters also from Oracle Press (Nov 2006). He has published articles in various international Magazines and is recognized as one of the leading database performance tuning experts in the world. Oracle Technology Network also recognizes him as an Oracle ACE. Gopal has worked with several of the biggest and busiest databases on the planet and has deep experience in the performance management and tuning of very large online transactional databases.

Inside This Book

(Learn More)
First Sentence
Speed is the word that defines the twenty-first century. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

11 of 12 people found the following review helpful By A Customer on 27 July 2004
Format: Paperback Verified Purchase
A well written book, easy to read. A simple solution to collecting all the session information you need for performance troubleshooting.
To date I have been looking for a single resource (book) to use for diagnosing performance issues. This is it! It doesn't matter if you are on Oracle 7 or 10g, this solution gathers the information you need with little overhead.
The book isn't selling third party products like many other books in its league.
Not finished the book yet but I already feel more confident in troubleshooting performance issues.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Amazon Customer on 26 May 2012
Format: Paperback
This is an excellent and well written approach to Oracle performance issues, but there is one major omission. Some of the views and packages it describes are part of the (not cheap) Oracle Diagnostic Pack which is not included in the Standard or even Enterprise licence. Without paying extra for this licence you are not even entitled to look at some of the views and grid pages it describes. AWR, ASH and ADDM, covered in chapter 9, are all part of this pack, but I could not find this mentioned anywhere in the book. Your use of them, however, will be flagged. If you work your way through chapter 9 on a production system, you could find yourself in the hole for a lot of money when the Oracle auditors come around.

The book covers many performance tuning diagnostic methods which do not rely on this pack, but there are no warnings about the ones that do. In the interests of fairness, I would suggest this as an update to a subsequent edition.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 38 reviews
15 of 17 people found the following review helpful
If you like YAPP, just get it! 11 Jan. 2005
By Amazon Customer - Published on
Format: Paperback
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'
13 of 15 people found the following review helpful
Authoratative landmark work on Oracle internals 23 Oct. 2004
By Tim Gorman - Published on
Format: Paperback
The book is simply spectacular, both for the quality of its writing as well as the depth of the material. Practical? Indeed, indispensible!

The three authors, Richmond Shee, Kirti Deshpande, and K Gopalakrishnan, have done a wonderful job in organizing a enormous subject area into manageable chunks. They have also managed to render potentially bone-dry source material into very readable text, interspersed heavily with code examples and output, sidebars, and analogies. This is a good read as well as an authoritative reference. I'm still unable to read it steadily for long periods of time, as the analogy of trying to drink from a fire-hose is relevant here. But picking it up and reading different sections, treating it like a reference, has proved rewarding. Richmond, Kirti, and K had an absolute "dream team" of reviewers on this book in Kyle Hailey, John Kanagaraj, Craig Shallahamer, and Graham Wood. The combined efforts of the three authors and the four technical editors blows my mind.

All I can say is - get it! You may (like me) not read it immediately. But, keep it handy. Along with the Google, Ixora, Asktom, JLComp, MetaLink websites, this book is the place to find explanation for the unexplainable in Oracle. Start skimming through it and recognize situations that had previously baffled now being explained (and proved) in full. It is like a light coming on.
7 of 7 people found the following review helpful
Great book 3 Sept. 2004
By Angela Simmons - Published on
Format: Paperback
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.
7 of 7 people found the following review helpful
OWI explained as it should be 22 Nov. 2004
By N. PINTO-DO-SOUTO - Published on
Format: Paperback
A lot of people have been talking about monitoring and tuning using the "wait interface". There are too many sites around with bits and pieces of the necessary information, but up until now there wasn't a complete source on the subject.

Having used Oracle since 1984, I have read just about every advanced book on Oracle databases. This one is right at the top of the list for anyone wanting to learn how to accurately monitor and tune Oracle databases.

Here at last is a single, complete and authoritative reference for all to use. And what I like the best: it is not restricted to a single version of Oracle. Simply the best reference right now.
8 of 9 people found the following review helpful
OWI Gold Mine !! 5 Jun. 2006
By Vinod Haval - Published on
Format: Paperback
An excellent read, I have to say that it exceeds my expectations. For those who are just getting exposed to the myths of OWI, a must read from cover to cover.

Having worked in Performance Tuning for the last few years I never come across a book which is complete in itself and needs no additional reference to other books or documents.

The authors of this book have done an excellent job in exposing invaluable information on Oracle wait Interface. Particularly, they targeted the most important waits that one must pay attention to while dealing with Oracle performance issues. On the contrary to misconceptions floating around usage of x$ which was thought to hamper performance the author clearly demonstrates its use throughout the book.

This is one of a kind book available. A book like this should be part of all serious DBAs reference collection. More importantly one of the very very few books that helps not only identifying the problem but actually offers a solution for the same....provides a cause for the event and ways to alleviate it.

Kudos to the authors for writing such a wonderful book and would highly recommend it for anybody wanting to plunge into the OWI gold mine.

Fantastic work


Vinod Haval
Were these reviews helpful? Let us know