latch cache buffers chains

select p1,p1raw from v$session_wait where event='latch: cache buffers chains';

select * from v$latch where name='cache buffers chains';
select * from (select addr,child#,gets,misses,sleeps from v$latch_children where name='cache buffers chains' order by sleeps desc ) where rownum<=20;
select * from v$latch_children where name='cache buffers chains' and addr='C000000425576648'

select to_char('13835058073068010400','XXXXXXXXXXXXXXXXXXXXXXXXXXX') from dual;

/* Formatted on 2014/7/15 13:33:23 (QP5 v5.256.13226.35510) */
  SELECT hladdr,
         obj,
         (SELECT object_name
            FROM dba_objects
           WHERE    (data_object_id IS NULL AND object_id = x.obj)
                 OR data_object_id = x.obj AND ROWNUM = 1)
            AS object_name,
         dbarfil,
         dbablk,
         tch
    FROM x$bh x
   WHERE hladdr IN ('C000000425576648')
ORDER BY tch DESC;

--根据FILE#,dbablk来找出对应对象。
select * from (select hladdr,ts#,file#,dbarfil,dbablk,tch from x$bh order by tch desc) where rownum<16;
select * from dba_extents where file_id=149 and 405350 between block_id and block_id + blocks - 1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15412087/viewspace-1776245/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15412087/viewspace-1776245/