Re: Wait Information
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxxxx>
- To: Tom.Terrian.ctr@xxxxxxx
- Date: Wed, 24 Sep 2008 09:40:57 -0500
Tom,
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.
Cary Millsap
http://carymillsap.blogspot.com
http://method-r.com
On Wed, Sep 24, 2008 at 9:03 AM, Terrian, Thomas J Mr CTR DLA J6DIB <
Tom.Terrian.ctr@xxxxxxx> 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.
>
> Thanks,
> Tom
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
