| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
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 |
