Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |