 Trade In this Item for up to £5.85
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning: A Practical Guide to Performance Diagnostics and Tuning (Oracle Press) for an Amazon.co.uk gift card of up to £5.85, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
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.
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
Inside This Book
(Learn More)
First Sentence
Speed is the word that defines the twenty-first century. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Speed is the word that defines the twenty-first century. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
11 of 12 people found the following review helpful
Format:Paperback
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.
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.
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.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
36 reviews
16 of 18 people found the following review helpful
If you like YAPP, just get it!
11 Jan 2005
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'
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'
8 of 8 people found the following review helpful
OWI explained as it should be
22 Nov 2004
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.
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.
14 of 16 people found the following review helpful
Authoratative landmark work on Oracle internals
23 Oct 2004
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.
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.
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
