FILE_ID |
NUMBER |
NOT NULL |
Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES ) |
FILE_NAME |
NUMBER |
|
The file name |
TS_NAME |
VARCHAR2(30) |
NOT NULL |
Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES ) |
FREQUENCY |
NUMBER |
|
The ping count |
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_WRITES |
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_WRITES |
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 resuse 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 resuse 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 |
N_2_S |
NUMBER |
|
Number of lock conversions from NULL-to-Shared for all blocks of the specified file |
N_2_SS |
NUMBER |
|
Number of lock conversions from NULL-to-Sub Shared for all blocks of the specified file |