Statistical System Tables

The following system tables contain historical data about the usage and the status of the DBMS. They are placed in a system schema EXA_STATISTICS that is automatically integrated in the namespace. These system tables can also be retrieved in the EXA_SYSCAT system table. Timestamps of historical statistics are stored in the current database time zone (DBTIMEZONE).

Statistics are updated periodically, for an explicit update, you can use the command FLUSH STATISTICS.

Most statistical system tables can be accessed by all users as read-only and are subject to the transactional concept explained in Transaction Management. Therefore, you may have to open a new transaction to see the updated data.

System tables with DBA in its name require the SELECT ANY DICTIONARY privilege to access them.