Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$CLASS_CACHE_TRANSFER

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