Oracle Wait Interface - Truly Practical | Oracle Wait Interface: A Practical Guide to Performance...

excellent | Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) | Kirtikumar Deshpande, K. Gopalakrishnan

books:


	• Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series) Kirtikumar Deshpande, K. Gopalakrishnan McGraw-Hill Osborne Media, 2004 - 400 pages average customer review:based on 32 reviews view larger image
	for more information click here

highly recommended

OWI - The new wave

I have been waiting for the release of this book after watching the presentation by Kirtikumar on searchoracle.com about wait interfaces. I have covered about 200 pages so far and i'm spellbound at the depth and granularity of the topics at which the authors have dealt with. I would heartily recommend it to anyone who wants to troubleshoot Oracle performance without any guess work or gimmicks and i'm raring to dive deep into the mystery of Oracle Internals.

Oracle Wait Interface - Truly Practical

There has been a lot of information published over the years in regards to the OWI. The trouble has always been that there was not enough of it available in a single reference.

This effort by Shee, Deshpande and Gopalkrishnan remedies that situation nicely. Not only is the OWI explained, but the authors go into great detail about the various types of sitations that may be causing excessive waits in many areas.

There are many other goodies included as well, but you'll have to discover those for yourself.

for more information click here

excellent

first i will congratulate for this excellent book oracle wait interface!
I'm standing before the last ocp test and think this book is best for the test to understand the comlicated subject.
i started for 9 years ago as dba and the performance tuning was always a terribly area for me.
slowly i unterstand and know the backgrounds (statspack, ...) but this book is the best addition i ever saw.

so i can go to the last examine with a realy good companion ........

thank you and wish you only the best

best regards to all readers

for more information click here

Simply Awsome!

DON'T BUY THIS BOOK......if you are looking for Oracle Wait Events _ONLY_!

This is not just a book on wait events; it's much...much more than that. It's part concepts on workings of Oracle database, part cook-book on troubleshooting typical problems. Overall - with the comprehensive coverage on all aspects of Oracle database-side tuning, it's the best book on performance troubleshooting. Perhaps the authors should have chosen a different name to convey the expanded meaning.

I have seen books on measuring response time down to microseconds, but as a practicing DBA, I'm more interested in solving the puzzle, i.e. reduce the time, not measure to the highest precision. There have been many books talking about slightly simplistic tuning excercise such as relocating redo logs to fast disks or reducing I/O by removing hot spots.

Where this book excels is bridging the gap between the perfect measurement and implementable solutions by explaining why's and how's of the problem. I was amazed how the authors put together rational explanations of common wait events like latch free, bolstered by the elaboration of internals like hash buckets, cache buffer chains and how to rectify those - it all seems so simple when it comes out in the book. Whether you are a veteran DBA who have seen all the battles since the Civil War or a rookie just starting out, this book is for you, a vital weapon in your arsenal, especially the scripts for identifying troublespots.

If I'm allowed to keep only one book on Oracle - this will be it.

for more information click here

Magnificient Effort

In the dark ages of the 90s, a few like Steve Adams, J P Lewis, Anjo Kolk ventured into the Internals of Oracle to reveal some of the secrets it held.

Continuing and exceeding the expectations of a much larger community of 'tuning' nerds, this new wonderfully presented book on OWI provides the best information available yet on Wait Interface based Oracle Performance Tuning.

The chapters are very well laid out and easy to understand. Though this book requires sound knowledge and understanding of the fundamentals of the Oracle Database, its resources are immensely useful for the inexperienced DBAs too.

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...

One of the biggest disappointments with most tuning books is the lack of information on Parallel Databases (more recently known as RAC in Oracle) and information on diagnostic capabilities.

These 2 chapters set apart this book from the rest of them in the market. Though the information on RAC wait events is not exhaustive, it is more than sufficient for someone to understand the concepts and work accordingly (or should we say dig deeper!).

The chapter discussing dumps and diagnostic events is something that DBAs have been waiting for years and now its finally here. This chapter has invaluable information about ORADEBUG (a great diagnostic utility) and other DUMP related commands.

On the whole, a book of this quality was always wanting and with the arrival of this one, we have nothing to complain about! Hope their next book/version will have more surprises in store

If there is one accurate book on Performance Tuning, this is it.

Best Regards
Anand Rao

for more information click here

reviews: 1, 2, 3, 4, 5, page 6, 7

hot