Warning in Exasol system log is generated when auditing data gets too large

Details

Detail name Value
Changelog Number 16087
Type Improvement
Status Resolved
Fix Versions Exasol 8.13.0
Resolution Date 2023-03-22

Background

When auditing is enabled, it keeps track of information for every query for as long as it is active. After a long time, this can end up using significant amounts of space and/or have a detrimental effect on the system performance. Auditing data can be deleted using the TRUNCATE AUDIT LOGS statement.

Improvement

Whenever the size of the auditing data reaches 25% of the size of Database RAM, a warning in the Exasol System Log is generated