Question:Is it possible to clean up old sessions from an AuditStore database to free space?
Answer:Please find attached to this article a .sql script: 'PurgeSessionsSQLJob - V2.sql'
This script may be leveraged as a one-time use, or recurring job to clean up old session data from a target AuditStore.
The script should be run against the target AuditStore database as a DBA. Default behavior will remove sessions older than 365 days. This value can be modified on line #9 of the script.
Please also refer to
KB-3394: Is it possible to purge audit sessions older than 'x' number of days for alternate/standalone mechanism for leveraging this tool.