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. |