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')