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;

  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/