Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> latch: cache buffers chains
Oracle 10g 10.2.0.2 (64 bit)
2 -node RAC
I am seeing only ONE session waiting on a CBC latch. Followed the metalink docs to identify the hot block without luck. See below.
select count(*), event from gv$session_wait where event like '%latch%' group by event order by 1 desc;
COUNT(*) EVENT
---------- ----------------------------------- 1 latch free
SELECT count(*) NUM_WAITERS, p1 FILE#, p2 BLK#, p3 CLASS FROM gv $session_wait WHERE event = 'latch: cache buffers chains' GROUP BY p1, p2, p3;
NUM_WAITERS FILE# BLK# CLASS ----------- ---------- ---------- ----------
1 2629049624 122 0
SELECT owner,segment_name,segment_type FROM dba_extents WHERE file_id=2629086424 and 122 BETWEEN block_id AND block_id + blocks;
no rows selected.
Any ideas to determine the root cause.
What does CLASS=0 mean?
File=2629049624 does not exit.
Any help/pointers would be appreciated.
Thanks
wagen
Received on Mon Apr 23 2007 - 09:53:38 CDT