Re: Wait Information
Date: Wed, 24 Sep 2008 09:40:57 -0500
A lot of very good documentation is available by Googling. There is Anjo Kolk's "YAPP" paper that started it all, and it's still an excellent reference. The Shee/Deshpande/Gopalakrishnan book<http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1222266618&sr=8-1>will help you, too.
As always with books and courses and the Internet, you'll find both good and bad information out there, and it can be difficult to tell what information is right and what is wrong. One technique we teach <http://method-r.com> is to use "strace" in conjunction with Oracle extended SQL trace on, say, a Linux box (strace doesn't work so well on Windows), which enables you to track the "wait events" as the Oracle kernel makes OS calls. Then you can use the Unix "man" utility to learn exactly what the OS call does. It's one way to get deeper and more reliable information than you can usually get by other means.
On Wed, Sep 24, 2008 at 9:03 AM, Terrian, Thomas J Mr CTR DLA J6DIB < Tom.Terrian.ctr_at_dla.mil> wrote:
> Does anyone have a good site/document that provides details on Oracle
> waits (from v$system_event)? Stuff like what the wait means, what is
> causing it, and how to fix it?
> I know they are listed in the Reference book but the information is very
> sparse and many of the waits are not even listed.