Buy this book..... | Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne...

Sooner or Later You'll need this book | 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

Performance Tuning Fundamentals with New Insights

Invaluable Oracle 10G performance tuning and diagnostics guide providing a contemporary, methodical approach to quickly identifying and eliminating critical Oracle bottlenecks in an effective and efficient manner i.e. unlike many technical books this one is extremely useful yet doesn't weigh more than your laptop. In particular, I found chapter 4 outstanding: provides a specific, concrete methodology for monitoring and collecting key wait event statistics using a combination of a logoff trigger and real time sampling with consideration to minimizing any additional overhead while simultaneously capturing all relevant wait statistics necessary for an accurate diagnosis. This is the first time I have come across this methodology and in testing I found it to be almost ingenious...and had I thought of it first I am sure it would fully qualify.
In short, this is the single most concise Oracle 10G tuning book on my shelf or the bookstores (actually, I own more Oracle books) providing a contemporary approach to efficient Oracle performance tuning, a brand-new performance statistics collection methodology [to me], and a great reference regarding the interpretation of standard Oracle wait events as well as traditional methods of Oracle tracing.

for more information click here

Buy this book.....

Every Oracle DBA needs this book. Simple as that. It not only makes Oracle wait events understandable, it gives you an application to install to collect and analyze them. If you want to drill deep into the internals, it lets you do that, as well. This is good stuff.

Sooner or Later You'll need this book

When the database is running too slowly, you really have two options, throw more iron at the problem, or make it work a bit smarter. Throwing more CPU's, more memory at the problem may be the easiest answer, after all it's the company's money. But it isn't likely to help for very long. The problems in the database will not go away by themselves. The growth of the database, the number of users or whatever will soon catch up with you. Or, for a whole lot less money, you can buy this book.

This book is basically on the performance features that have been incorporated into Oracle 10g that can help identify the problem areas. Using these features, the database will tell you where it's spending its time. This is not a book that will tell you how to optimize a SQL statement. But if you know that Oracle is spending more of its time on this statement, then you at least know where to start looking -- maybe it's something in the statement, perhaps changing the index will help (it often will) but at least you know where to start looking.

There's a simple conclusion to reviewing this book. If you're going to be responsible for running a big Oracle system, buy it.

for more information click here

OWI explained as it should be

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.

for more information click here

"OWI: Practical Guide..." is a must-have tuning companion

This book is very well organized, as it progresses from what wait events are and where they can be found, to interpretation of important events and common causes, and finally how to collect data and monitor events for problem resolution.
In the past, understanding wait events has been a random walk, where I have attempted to decipher specific wait events that were troublesome in my environment. This has often been a tedious and frustrating exercise. This book puts it all together in a concise, meaningful way that results in a strategy to pro-actively monitor and diagnose wait-related problems. No more digging around looking for bits and pieces of information related to wait events, this book has everything you need to manage, monitor, and tune your database environments.

for more information click here

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

hot