Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 28 of 211


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback