V$CLASS_CACHE_TRANSFER 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 |
|---|---|---|
CLASS |
CHAR(10) |
Block class; always data block |
X_2_NULL |
NUMBER |
Number of blocks with Exclusive-to-NULL conversions; always 0 |
X_2_NULL_FORCED_WRITE |
NUMBER |
Number of Exclusive-to-NULL forced writes; always 0 |
X_2_NULL_FORCED_STALE |
NUMBER |
Number of Exclusive-to-NULL blocks converted to CR; always 0 |
X_2_S |
NUMBER |
Number of blocks with Exclusive-to-Shared conversions; always 0 |
X_2_S_FORCED_WRITE |
NUMBER |
Number of Exclusive-to-Shared forced writes; always 0 |
S_2_NULL |
NUMBER |
Number of blocks with Shared-to-NULL conversions; always 0 |
S_2_NULL_FORCED_STALE |
NUMBER |
Number of Shared-to-NULL blocks converted to CR; always 0 |
NULL_2_X |
NUMBER |
Number of blocks with NULL-to-Exclusive conversions; always 0 |
S_2_X |
NUMBER |
Number of blocks with Shared-to-Exclusive conversions; always 0 |
NULL_2_S |
NUMBER |
Number of blocks with NULL-to-Shared conversions; always 0 |
CR_TRANSFER |
NUMBER |
Number of CR blocks transferred; always 0 |
CURRENT_TRANSFER |
NUMBER |
Number of current blocks transferred; always 0 |