GV$LOCK_ACTIVITY definition in Oracle 8i / www.oracledba.ru
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