Re: Researching latch efficiency

You can google the individual wait event (or use metalink, etc.) and find typically lots of good info about what wait event is what. You could also use Confio's outstanding tool Ignite (trial version available on their web site, I believe) to get a useful and graphical tool to help you analyze what query is producing which events. That tool will typically also give you a decent description of an event, what causes it, who usually fixes it (DBA vs. Application vs. SA, etc.) and so on.

I imagine there are other good tools out there as well, but I've gotten quite a bit of use out of Ignite and really like it.

oracle-l-bounce_at_freelists.org wrote on 06/19/2008 10:50:00 AM:

> <oracle-l_at_freelists.org>
>
> Hi everyone –
> Forgive me if this has been asked before… how / where can I
> research what the various wait events mean? I’m seeing an event
> called “messages” and that is such a common word it is challenging
> for search engines to identify when I search “oracle wait event
messages”.
> __thanks
>
> p.s. using Ora10.2.0.4 on HPUX Itanium
>
>
> Daniel Wittry
> Sr. Database Administrator, Global SCI
> HAVI Global Solutions (http://www.HaviGS.com)
>
> P Please consider the environment before printing this email.
>
>

>
>
> ************************************************************************
> This e-mail and any accompanying documents or files contain
> information that is the
> property of HAVI Global Solutions, that is intended solely for those
> to whom this e-mail is addressed
> (i.e., those identified in the "To" and "Cc" boxes), and that is
> confidential, proprietary,
> and/or privileged. If you are not an intended recipient of this e-
> mail, you are hereby
> notified that any viewing, use, disclosure, forwarding, copying, or
> distribution of any of
> this information is strictly prohibited and may be subject to legal
> sanctions. If you have
> received this e-mail in error, please notify the sender immediately
> of any unintended
> recipients, and delete the e-mail, all attachments, and all copies
> of both from your system.
>
> While we have taken reasonable precautions to ensure that any
> attachments to this e-mail
> have been swept for viruses, we cannot accept liability for any
> damage sustained as a
> result of software viruses.
> ************************************************************************

--
http://www.freelists.org/webpage/oracle-l