[SOL-222] EXA_STATISTICS schema Created: 16.01.2015 Updated: 02.04.2020
|Affects Version/s:||EXASolution 4.2.0, EXASolution 5.0, EXASOL 6.0.0, Exasol 6.1.0|
|Reporter:||Captain EXASOL||Assignee:||Captain EXASOL|
EXASolution offers numerous statistical system tables containing data about the usage and the status of the DBMS. These system tables are located in the "EXA_STATISTICS" schema but are automatically integrated into the current namespace. This means that if an object with the same name does not exist in the current schema, they can be queried without the schema name, "EXA_STATISTICS". Otherwise, the system tables can be accessed via the respective
In general there are four different classes of statistical data:
For each class there are four shapes:
Therefore there are a total of 16 tables. Examples:
If Auditing is enabled for the database, the tables EXA_DBA_AUDIT_SESSION and EXA_DBA_AUDIT_SQL are used to trace all sessions/queries connected to/sent to the database.
Profiling can be used to analyze queries in detail. Therefore the tables EXA_DBA_PROFILE_LAST_DAY and EXA_USER_PROFILE_LAST_DAY can be used. See SOL-75 or manual section 3.4. for further information on profiling.
The table EXA_DBA_TRANSACTION_CONFLICTS lists all transaction conflicts that occured. This table can be accessed by users having the "SELECT ANY DICTIONARY" system privilege.
The table EXA_SYSTEM_EVENTS contains system events:
Determining the overall average compression ratio, average raw database size and average compressed database size on monthly basis:
Appendix A.2.3. in the user manual lists all statistical system tables including information on all available columns.
|Category 1:||Database Administration - Performance|