GV$LOCK_ACTIVITY
select inst_id, -- INST_ID NUMBER decode -- FROM_VAL VARCHAR2(4) (indx, 0, 'NULL', 1, 'NULL', 2, 'S', 3, 'S', 4, 'X', 5, 'X', '?'), decode -- TO_VAL VARCHAR2(4) (indx, 0, 'S', 1, 'X', 2, 'NULL', 3, 'X', 4, 'NULL', 5, 'S', '?'), decode -- ACTION_VAL VARCHAR2(50) (indx, 0, 'Lock buffers for read', 1, 'Lock buffers for write', 2, 'Make buffers CR (no write) ', 3, 'Upgrade read lock to write', 4, 'Make buffers CR (write dirty buffers) ', 5, 'Downgrade write lock to read (write dirty buffers) ', 'Should not happen'), conv -- COUNTER NUMBER from x$le_stat where conv > 0

home |  up  |  mailbox