SNAP_ID |
NUMBER |
|
Unique snapshot ID |
DBID |
NUMBER |
|
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
|
Instance number for the snapshot |
TS# |
NUMBER |
|
Tablespace number |
OBJ# |
NUMBER |
|
Dictionary object number |
DATAOBJ# |
NUMBER |
|
Data object number |
LOGICAL_READS_TOTAL |
NUMBER |
|
Cumulative value for logical reads |
LOGICAL_READS_DELTA |
NUMBER |
|
Delta value for logical reads |
BUFFER_BUSY_WAITS_TOTAL |
NUMBER |
|
Cumulative value for buffer busy waits |
BUFFER_BUSY_WAITS_DELTA |
NUMBER |
|
Delta value for buffer busy waits |
DB_BLOCK_CHANGES_TOTAL |
NUMBER |
|
Cumulative value for db block changes |
DB_BLOCK_CHANGES_DELTA |
NUMBER |
|
Delta value for db block changes |
PHYSICAL_READS_TOTAL |
NUMBER |
|
Cumulative value for physical reads |
PHYSICAL_READS_DELTA |
NUMBER |
|
Delta value for physical reads |
PHYSICAL_WRITES_TOTAL |
NUMBER |
|
Cumulative value for physical writes |
PHYSICAL_WRITES_DELTA |
NUMBER |
|
Delta value for physical writes |
PHYSICAL_READS_DIRECT_TOTAL |
NUMBER |
|
Cumulative value for physical reads direct |
PHYSICAL_READS_DIRECT_DELTA |
NUMBER |
|
Delta value for physical reads direct |
PHYSICAL_WRITES_DIRECT_TOTAL |
NUMBER |
|
Cumulative value for physical writes direct |
PHYSICAL_WRITES_DIRECT_DELTA |
NUMBER |
|
Delta value for physical writes direct |
ITL_WAITS_TOTAL |
NUMBER |
|
Cumulative value for ITL waits |
ITL_WAITS_DELTA |
NUMBER |
|
Delta value for ITL waits |
ROW_LOCK_WAITS_TOTAL |
NUMBER |
|
Cumulative value for row lock waits |
ROW_LOCK_WAITS_DELTA |
NUMBER |
|
Delta value for row lock waits |
GC_CR_BLOCKS_SERVED_TOTAL |
NUMBER |
|
Cumulative value for global cache CR blocks served |
GC_CR_BLOCKS_SERVED_DELTA |
NUMBER |
|
Delta value for global cache CR blocks served |
GC_CU_BLOCKS_SERVED_TOTAL |
NUMBER |
|
Cumulative value for global cache current blocks served |
GC_CU_BLOCKS_SERVED_DELTA |
NUMBER |
|
Delta value for global cache current blocks served |
SPACE_USED_TOTAL |
NUMBER |
|
Cumulative value for space used |
SPACE_USED_DELTA |
NUMBER |
|
Delta value for space used |
SPACE_ALLOCATED_TOTAL |
NUMBER |
|
Cumulative value for space allocated |
SPACE_ALLOCATED_DELTA |
NUMBER |
|
Delta value for space allocated |
TABLE_SCANS_TOTAL |
NUMBER |
|
Cumulative value for table scans |
TABLE_SCANS_DELTA |
NUMBER |
|
Delta value for table scans |