Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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 Go to next page
View PDF

V$CLASS_CACHE_TRANSFER

V$CLASS_CACHE_TRANSFER displays the number of blocks pinged per block class. Use this view to compare contentions for blocks in different classes.

Column Datatype Description

CLASS

VARCHAR2(18)

The block class

X_2_NULL

NUMBER

Number of lock conversions from Exclusive-to-NULL for all blocks of the specified CLASS

X_2_NULL_FORCED_WRITE

NUMBER

Number of forced writes that occur for blocks of the specified CLASS due to Exclusive-to-NULL conversions

X_2_NULL_FORCED_STALE

NUMBER

Number of times a block in the CLASS was made STALE due to Exclusive-to-NULL conversions

X_2_S

NUMBER

Number of lock conversions from Exclusive-to-Shared for all blocks of the specified CLASS

X_2_S_FORCED_WRITE

NUMBER

Number of forced writes that occur for blocks of the specified CLASS due to Exclusive-to-Shared conversions

S_2_NULL

NUMBER

Number of lock conversions from Shared-to-NULL for all blocks of the specified CLASS

S_2_NULL_FORCED_STALE

NUMBER

Number of times a block in the CLASS was made STALE due to Shared-to-NULL conversions

NULL_2_X

NUMBER

Number of lock conversions from NULL-to-Exclusive for all blocks of the specified CLASS

S_2_X

NUMBER

Number of lock conversions from Shared-to-Exclusive for all blocks of the specified CLASS

NULL_2_S

NUMBER

Number of lock conversions from NULL-to-Shared for all blocks of the specified CLASS