Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Latch free waits..

Latch free waits..

From: Thomas <manojtom007_at_yahoo.com>
Date: 26 Jul 2004 12:02:25 -0700
Message-ID: <65182aad.0407261102.1746c19e@posting.google.com>


High amount of latch free waits is slowing down sessions on db.. any ideas on how to debug further?

    LATCH# NAME

---------- ----------------------------------------------------------------
       156 shared pool
       157 library cache
       159 library cache pin allocation
        98 cache buffers chains

latch sleep /impacts stats..

LATCH TYPE                                 IMPACT SLEEP RATE WAITS
HOLDING LEVEL
------------------------------------- ----------- ----------
------------- -----
library cache                             3589515      0.08%      
3500279     5
shared pool                                800304      0.03%       
772812     7
library cache pin allocation               625205      0.05%       
613239     4
row cache objects                           25799      0.00%        
24582     4
row cache enqueue latch                     12366      0.00%        
12171     5
library cache pin                            3985      0.00%         
3983     4
Received on Mon Jul 26 2004 - 14:02:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US