GV$LOCKS_WITH_COLLISIONS

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