demo02.sql

Expert Oracle Database Architecture 9i and 10g sql源码

select file#, block#, count(*)
from v$bh
group by file#, block#
having count(*) > 3
order by 3
/