Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Latch free waits..
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 WAITSHOLDING 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 4Received on Mon Jul 26 2004 - 14:02:25 CDT