|
FILE_NUMBER |
NUMBER |
Number of the datafile |
|
FREQUENCY |
NUMBER |
The frequency |
|
X_2_NULL |
NUMBER |
Number of lock conversions from Exclusive-to-NULL for all blocks in the file |
|
X_2_NULL_FORCED _WRITE |
NUMBER |
Number of forced writes that occur for blocks of the specified file due to Exclusive-to-NULL conversions |
|
X_2_NULL_FORCED _STALE |
NUMBER |
Number of times a block in the file was made STALE due to Exclusive-to-NULL conversions |
|
X_2_S |
NUMBER |
Number of lock conversions from Exclusive-to-Shared for all blocks in the file |
|
X_2_S_FORCED_WRITE |
NUMBER |
Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Shared conversions |
|
X_2_SSX |
NUMBER |
Number of lock conversions from Exclusive-to-Sub Shared Exclusive for all blocks in the file |
|
X_2_SSX_FORCED _WRITE |
NUMBER |
Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Sub Shared Exclusive conversions |
|
S_2_NULL |
NUMBER |
Number of lock conversions from Shared-to-NULL for all blocks in the file |
|
S_2_NULL_FORCED _STALE |
NUMBER |
Number of times a block in the file was made STALE due to Shared-to-NULL conversions |
|
SS_2_NULL |
NUMBER |
Number of lock conversions from Sub Shared-to-NULL for all blocks in the file |
|
WRB |
NUMBER |
Number of times the instance received a write single buffer cross instance call for this file |
|
WRB_FORCED_WRITE |
NUMBER |
Number of blocks written due to write single buffer cross instance calls for this file |
|
RBR |
NUMBER |
Number of times the instance received a reuse block range cross instance call for this file |
|
RBR_FORCED_WRITE |
NUMBER |
Number of blocks written due to reuse block range cross instance calls for this file |
|
RBR_FORCED_STALE |
NUMBER |
Number of times a block in this file was made STALE due to reuse block range cross instance calls |
|
CBR |
NUMBER |
Number of times the instance received a checkpoint block range cross instance call for this file |
|
CBR_FORCED_WRITE |
NUMBER |
Number of blocks in this file which were written due to checkpoint cross range cross instance calls |
|
NULL_2_X |
NUMBER |
Number of lock conversions from NULL-to-Exclusive for all blocks of the specified file |
|
S_2_X |
NUMBER |
Number of lock conversions from Shared-to-Exclusive for all blocks of the specified file |
|
SSX_2_X |
NUMBER |
Number of lock conversions from Sub Shared Exclusive-to-Exclusive for all blocks of the specified file |
|
NULL_2_S |
NUMBER |
Number of lock conversions from NULL-to-Shared for all blocks of the specified file |
|
NULL_2_SS |
NUMBER |
Number of lock conversions from NULL-to-Sub Shared for all blocks of the specified file |
|
OP_2_SS |
NUMBER |
Number of pcm locks ss locks opened. 0 in Oracle 8.1 |
