V$LOCK_ACTIVITY is deprecated. The information that was provided in this view is now provided in the V$INSTANCE_CACHE_TRANSFER and V$SEGMENT_STATISTICS views.
| 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 |