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: cache buffers chains

latch: cache buffers chains

From: <wagen123_at_yahoo.com>
Date: 23 Apr 2007 07:53:38 -0700
Message-ID: <1177340018.513940.258920@n76g2000hsh.googlegroups.com>


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

Original text of this message

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