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