GV$LOCKS_WITH_COLLISIONS definition in Oracle Database 11.2
GV$LOCKS_WITH_COLLISIONS

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

home |  up