Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

Oracle Wait Interface and over 300,000 other books are available for Amazon Kindle � Amazon�s new wireless reading device. Learn more

Quantity:

More Buying Choices

34 used & new from $19.99

Have one to sell? Sell yours here

Share with Friends

Share your own customer images

Search inside this book

Start reading Oracle Wait Interface on your Kindle in under a minute. Don�t have a Kindle? Get yours here.

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) (Paperback)

by Richmond Shee (Publisher), Kirtikumar Deshpande (Author), K. Gopalakrishnan (Author) "Speed is the word that defines the twenty-first century..." (more)
Key Phrases: write wait event, file parallel write event, following key thoughts, Wait Parameters Wait, Oracle Wait Interface, Active Session History (more...)

5.0 out of 5 stars See all reviews (33 customer reviews)

List Price:	$52.99
Price:	$34.54 & this item ships for FREE with Super Saver Shipping. Details
You Save:	$18.45 (35%)

Upgrade this book for $9.99 more, and you can read, search, and annotate every page online. See details

In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, July 7? Choose One-Day Shipping at checkout. Details

18 new from $26.92 16 used from $19.99

Also Available in:	List Price:	Our Price:	Other Offers:
Kindle Edition (Kindle Book)		$32.36

Frequently Bought Together

Price For All Three: $111.41

Show availability and shipping details

This item: Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) by Richmond Shee
In Stock.
Ships from and sold by Amazon.com.
This item ships for FREE with Super Saver Shipping. Details
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) by Richard Niemiec
In Stock.
Ships from and sold by Amazon.com.
This item ships for FREE with Super Saver Shipping. Details
Oracle Database 10g Real Application Clusters Handbook (Osborne ORACLE Press Series) by K Gopalakrishnan
In Stock.
Ships from and sold by Amazon.com.
This item ships for FREE with Super Saver Shipping. Details

Customers Who Bought This Item Also Bought

Oracle Database 10g Real Application Clusters Handbook (Osborne ORACLE Press Series)

by K Gopalakrishnan

4.7 out of 5 stars (22) $39.08

Oracle Database 10g RMAN Backup & Recovery

by Matthew Hart

4.8 out of 5 stars (8) $37.79

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

by Thomas Kyte

4.7 out of 5 stars (31) $31.49

Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) (v. 1)

by Jonathan Lewis

4.6 out of 5 stars (27) $40.20

Optimizing Oracle Performance

by Cary Millsap

4.7 out of 5 stars (27) $23.07

› Explore similar items

Editorial Reviews

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

See all Editorial Reviews

Product Details

Paperback: 400 pages
Publisher: McGraw-Hill Osborne Media; 1st edition (June 9, 2004)
Language: English
ISBN-10: 007222729X
ISBN-13: 978-0072227291
Product Dimensions: 9.1 x 7.4 x 0.9 inches
Shipping Weight: 1.4 pounds (View shipping rates and policies)

Average Customer Review: 5.0 out of 5 stars See all reviews (33 customer reviews)

Amazon.com Sales Rank: #308,288 in Books (See Bestsellers in Books)
Popular in this category: (What's this?)
#13 in Books > Computers & Internet > Databases > Oracle > Tuning

Would you like to update product info or give feedback on images?

Inside This Book (learn more)

First Sentence:
Speed is the word that defines the twenty-first century. Read the first page

Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
write wait event, file parallel write event, following key thoughts, log file switch completion, write complete waits event, full table scan operation, log file sync, parse elapsed time, enqueue type, enqueue hash table, cache buffers chains, time model statistics, wait event views, enqueue name, free wait event, row cache lock, space wait event, wait event information, write batch size, trace name context, common wait events, hash latches, log file parallel write, buffer busy waits event, level bmb

Key Phrases - Capitalized Phrases (CAPs): (learn more)
Wait Parameters Wait, Oracle Wait Interface, Active Session History, Real Application Clusters, Automatic Workload Repository, Enterprise Manager, Name Type, Deq Credit, Preserved Snapshot Sets, Wait Time One, Session Details, Automatic Database Diagnostic Monitor, Oracle Corporation, Oracle Support, Advisor Central, View Report, Database Control, Database Release, Tuning Advisor, Execution Message Dequeue, Period Duration, Query Idle Wait, Sun Solaris, Wait Time Actual

New!
Books on Related Topics | Concordance | Text Stats

Citations (learn more)

This book cites 2 books:

Optimizing Oracle Performance by Cary Millsap in Front Matter
In Search of Clusters (2nd Edition) by Gregory Pfister in Back Matter

Books on Related Topics (learn more)

Oracle 10g RAC Grid, Services & Clustering by Murali Vallath

Discusses:

Pro Oracle Database 10g RAC on Linux by Julian Dyke

Discusses:

Oracle9i DBA 101 by Marlene Theriault

Discusses:

Oracle High Performance Tuning for 9i and 10g by Gavin JT Powell

Discusses:

What Do Customers Ultimately Buy After Viewing This Item?

	72% buy the item featured on this page: Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) 5.0 out of 5 stars (33) $34.54
	15% buy Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series) 4.9 out of 5 stars (15) $37.79
	5% buy Oracle Database 10g RMAN Backup & Recovery 4.8 out of 5 stars (8) $37.79
	5% buy Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions 4.7 out of 5 stars (31) $31.49

Explore similar items

Tags Customers Associate with This Product

(What's this?)

Click on a tag to find related items, discussions, and people.

db(1)

oracle(1)

oracle tuning(1)

Help others find this product — tag it for Amazon search

No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Customer Reviews

33 Reviews

5 star:		(32)
4 star:		(1)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Average Customer Review

5.0 out of 5 stars (33 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars Authoratative landmark work on Oracle internals, October 23, 2004

By	Tim Gorman (Evergreen, CO USA) - See all my reviews

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.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

16 of 17 people found the following review helpful:

5.0 out of 5 stars If you like YAPP, just get it!, January 10, 2005

By	Jan M. Vanmourik "Oracle performance specialist" (Houston, Texas, USA) - See all my reviews (REAL NAME)

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'

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

8 of 8 people found the following review helpful:

5.0 out of 5 stars OWI Gold Mine !!, June 5, 2006

By	Vinod Haval - See all my reviews (REAL NAME)

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
From,
Vinod Haval

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all 33 customer reviews...

Most Recent Customer Reviews

5.0 out of 5 stars Even Five Years After Publication, this Book Still Belongs on the Bookshelf Next to the Other Worthy Books
For the last couple years I debated whether or not to buy this book, or for that matter any additional book, on the topic of Oracle's wait event interface. Read more

Published 20 days ago by Charles Hooper

5.0 out of 5 stars Oracle Wait interface
Excellent condition.
Its as good as new - though i paid second hand prices for it :)

Published 20 months ago by Ashok Naidu

5.0 out of 5 stars Excellent examples - easy to understand and use
I read the book and was immediately able to get to the root causes of a slow running Oracle database. Very well organized.

Published on March 8, 2007 by SRS

5.0 out of 5 stars Skillful Oracle book!
The way in which the concepts are explained by the authors is Skillful.
Tired of reading obscure explanations about latches? Read more

Published on January 3, 2007 by Gustavo Restuccia

5.0 out of 5 stars Kirtikumar Deshpande, K. Gopalakrishnan are the Best Authors !
I loved this book and it has helped me many many times to reduce the contention in database , thus by improving the performance by 100% to 150%... Read more

Published on November 10, 2006 by Weekend Woodworker

5.0 out of 5 stars Bye Bye Cache Hit Ratio
This is one of my favorite books. It gives easy to understand descriptions and examples. It is a must have for tuning. Read more

Published on July 29, 2006 by ORA-04031

5.0 out of 5 stars Amazing Oracle performance book !
I bought this book in order to improve my skills in performance tuning and I have to say that it exceeds my expectations. Read more

Published on January 16, 2006 by L. Larwence

4.0 out of 5 stars Not enough on improving performance
This book provides plenty of suggestions on how to determine the bottlenecks of Oracle database performance. Read more

Published on October 12, 2005 by Jaewoo Kim

5.0 out of 5 stars OWI: An excellent reference and a must-read book for Oracle DBAs
The authors of this book have done an excellent job in exposing invaluable information on Oracle wait Interface. Read more

Published on July 14, 2005 by Amir Hameed

5.0 out of 5 stars Excellent Book
Hi,

My Heartiest Congratulations to the Authors of the Book for an Excellent Book.

I am in Performance Tuning since last few years and have never come... Read more

Published on May 3, 2005 by Vivek Sharma

› See all 33 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jsOnDisplayBlock { display: none; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; }