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/