Re: latch free wait event

[Wolfgang Breitling]

The number of waits is irrelevant. What matters is the time waited which in 
your case shows 0, but I assume that is because you have not set 
timed_statistics to true. Without that the data from v$system_event are 
worthless. Cary will probably step in here and tell you that even with 
timed_statistics that data is at best of dubious worth.

At 02:49 PM 9/4/2003 -0800, you wrote:

                                System-wide Wait Analysis
                                 for current wait events
                                                                    Average
Event                                 Total  Seconds        Total      Wait
Name                                Waits  Waiting     Timeouts  (in secs)
-------------               ---------   ---------       ---------
-----------
latch free                            1,459        0         1,393      .000
After querying v$system_event my biggest concern is the "latch free"  wait
event. I understand that latch free is "the process waits for a latch that
is currently busy ( held by another process).    How can I drill down and
find the cause of this?   I have a feeling it is about rollback or redo
logs.
thanks,



David Ehresmann

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).