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