V$LOCK_ELEMENT definition in Oracle Database 11.2
V$LOCK_ELEMENT

select
  lock_element_addr,                       -- LOCK_ELEMENT_ADDR RAW(8)
  indx,                                    -- INDX NUMBER
  class,                                   -- CLASS NUMBER
  lock_element_name,                       -- LOCK_ELEMENT_NAME NUMBER
  mode_held,                               -- MODE_HELD NUMBER
  block_count,                             -- BLOCK_COUNT NUMBER
  releasing,                               -- RELEASING NUMBER
  acquiring,                               -- ACQUIRING NUMBER
  invalid,                                 -- INVALID NUMBER
  flags                                    -- FLAGS NUMBER
from
  gv$lock_element
where
  inst_id = USERENV('Instance')

home |  up