Select distinct owner,segment_name,partition_name,segment_type from dba_extents a ,
(Select obj, dbarfil, dbablk from x$bh where Hladdr in (select addr from (Select addr from
v$latch_children where name='cache buffers chains' order by sleeps desc) where rownum = a.block_id and b.dbablk<( a.block_id+a.blocks);
用这个语句可以找到热点segment |