| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
V$LOCK_ACTIVITY is deprecated.
| Column | Datatype | Description | 
|---|---|---|
FROM_VAL | 
CHAR(4) | 
Global Cache Resource initial state; always NULL | 
TO_VAL | 
CHAR(1) | 
Global Cache Resource initial state; always S | 
ACTION_VAL | 
CHAR(21) | 
Description of the conversion; always Lock buffers for read | 
COUNTER | 
NUMBER | 
Number of times the lock operation executed |