GV$LOCKS_WITH_COLLISIONS

select
inst_id,                 -- INST_ID NUMBER
lock_element_addr        -- LOCK_ELEMENT_ADDR RAW(4)
from
gv$bh 
where
(forced_writes + forced_reads) > 10 
group by lock_element_addr,
inst_id 
having count (*) >= 2
home |  up  |  mailbox