Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$TEMP_CACHE_TRANSFER

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