9.105 V$TEMP_CACHE_TRANSFER
V$TEMP_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 |
---|---|---|
|
|
Number of the temp file |
|
|
Number of blocks with Exclusive-to-NULL conversions; always |
|
|
Number of Exclusive-to-NULL forced writes; always |
|
|
Number of Exclusive-to-NULL blocks converted to CR; always |
|
|
Number of blocks with Exclusive-to-Shared conversions; always |
|
|
Number of Exclusive-to-Shared forced writes; always |
|
|
Number of blocks with Shared-to-NULL conversions; always |
|
|
Number of Shared-to-NULL blocks converted to CR; always |
|
|
Number of reuse blocks cross-instance calls; always |
|
|
Number of blocks written due to reuse blocks cross-instance calls; always |
|
|
Number of blocks with NULL-to-Exclusive conversions; always |
|
|
Number of blocks with Shared-to-Exclusive conversions; always |
|
|
Number of blocks with NULL-to-Shared conversions; always |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: