RE: Researching latch efficiency

Thanks everyone for your responses.

I'm using Quest's Spotlight and wonder if it means "latch: messages". I
may need to open a ticket with Quest Support to explain the display in
their GUI.

 

Not sure if this is the one I'm waiting on. I'll look deeper.

sql> select * from v$event_name where name = 'latch: messages';

 

The online Oracle doc referenced by Jared (thanks J!) does not have all
889 wait events documented for 10.2.0.4. I doubt I'm gonna find it.  :-)

 

__thanks for your help

 

************************************************************************
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