GV$LOCK_ELEMENT
select inst_id, -- INST_ID NUMBER le_addr, -- LOCK_ELEMENT_ADDR RAW(4) indx, -- INDX NUMBER le_class, -- CLASS NUMBER name, -- LOCK_ELEMENT_NAME NUMBER le_mode, -- MODE_HELD NUMBER le_blks, -- BLOCK_COUNT NUMBER le_rls, -- RELEASING NUMBER le_acq, -- ACQUIRING NUMBER le_inv, -- INVALID NUMBER le_flags -- FLAGS NUMBER from x$le

home |  up  |  mailbox