Rob Smyth's Blog

It's a perfect name isn't it?  The first time I saw the name it felt like I was going to get something that would allow me to "sleep" the database until I wanted it to wake up again.  I could then turn this off in a benchmark and be a performance guru!

At least I got the performance bit right.  Did you know that "Oracle professionals have been slowly migrating
away from performance analysis techniques that focused on blanket
system ratios to a methodology that instead zeros in on where a system,
application, or session is spending its time. Referred to as wait-based
analysis or bottleneck analysis, its goal is to uncover the true nature
of performance degradation by determining the exact causes of
throughput hindrances."  This is the Oracle Wait Interface

This has been brought to my attention by a customer who has recently purchased a book on this subject.

As always a different view on performance can sometimes help break a problem and I have it on good authority that this has been used in a number of  accounts by Oracle and non-Oracle experts alike, so I hope that this will prove to be another technique to add to the performance kitbag.