select * from (
select HLADDR,TS#,FILE#,DBABLK,TCH , CHILD#,GETS,MISSES,SLEEPS
from x$bh x,
(select * from (
select CHILD# ,ADDR,GETS,MISSES,SLEEPS from v$latch_children where name = 'cache buffers chains' order by 5 desc
)
where rownum < 2 ) y
where x.hladdr = y.addr
order by tch desc
) where rownum < 2
/
