V$LOCK_ACTIVITY definition in Oracle Database 11.2

V$LOCK_ACTIVITY

SELECT
  FROM_VAL,                                -- FROM_VAL CHAR(4)
  TO_VAL,                                  -- TO_VAL CHAR(1)
  ACTION_VAL,                              -- ACTION_VAL CHAR(21)
  COUNTER                                  -- COUNTER NUMBER
FROM
  GV$LOCK_ACTIVITY
where
  INST_ID = USERENV('INSTANCE')

home | up