V$TEMP_CACHE_TRANSFER is deprecated.
| Column | Datatype | Description |
|---|---|---|
FILE_NUMBER |
NUMBER |
Number of the tempfile |
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 |
RBR |
NUMBER |
Number of reuse blocks cross-instance calls; always 0 |
RBR_FORCED_WRITE |
NUMBER |
Number of blocks written due to reuse blocks cross-instance calls; 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 |