The system table DATASTATISTICS describes the current fill level of the database instance and the maximum fill level since the last time the database instance was started.
DATASTATISTICS
USABLESIZE |
FIXED(20) |
Data area available for data (KB) |
USEDSIZE |
FIXED(20) |
Memory in data area that is actually used for data (KB) |
USEDSIZEPERCENTAGE |
FIXED(3) |
Memory in data area that is actually used for data (%) |
DATAFULL |
CHAR(3) |
Data area is full (YES | NO) |
USEDSIZEONVOLUMES |
FIXED(20) |
Amount of data written to data area (KB) |
USEDSIZENOTONVOLUMES |
FIXED(20) |
Amount of permanent data that has to be written to data area at next savepoint (KB) |
USEDPERMANENTSIZE |
FIXED(20) |
Data area used for permanent data (KB) |
USEDTEMPORARYSIZE |
FIXED(20) |
Data area (KB) used for temporary data |
MAXUSEDSIZE |
FIXED(20) |
Maximum data area used for data at a savepoint (KB) |
MAXUSEDPERMANENTSIZE |
FIXED(20) |
Maximum data area used for permanent data at a savepoint (KB) |
MAXUSEDTEMPORARYSIZE |
FIXED(20) |
Maximum data area used for temporary data at a savepoint (KB) |
INCREMENTALBACKUPSIZE |
FIXED(20) |
Amount of data that needs to be backed up in next incremental backup (KB) |
LASTEMERGENCYHISTORYCLEANUP |
TIMESTAMP |
Time at which undo log files were last deleted due to lack of space in data area (according to history file) |
CONVERTERVERSION |
FIXED(10) |
The converter data saved to the data area at the last savepoint is assigned a unique number (converter version). This number is stored in the restart information. |
MAXTEMPORARYDATAPAGENUMBER |
FIXED(10) |
Highest page number available for temporary pages |
MAXPERMANENTDATAPAGENUMBER |
FIXED(10) |
Highest page number available for permanent pages |
MAXPERMANENTSTATICDATAPAGENUMBER |
FIXED(10) |
Highest page number available for permanent, static pages |
See also:
Evaluating System Tables, DATASTATISTICS