|
FILE_ID
|
NUMBER
|
NOT NULL
|
Datafile identifier number (to find the 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
|
