GV$GC_ELEMENTS_WITH_COLLISIONS
select USERENV ('Instance'), -- INST_ID NUMBER lock_element_addr -- GC_ELEMENT_ADDR RAW(4) from v$bh where (forced_writes + forced_reads) > 10 group by lock_element_addr having count (*) >= 2

home |  up  |  mailbox