Best way to cleanup sys_audit

[Rashmi Bansal]

I wanted to know if there is any way to cleanup safely sys_audit data from the multiple shards

[Mark Roethof]

Hi there,

Have you already undertaken any actions? Or inventarisation of what to cleanup? Or is your question just about how literally to safely delete without stressing the instance?

I am currently writing a series on the Database Footprint which might interest you (still some blogs in draft). Amongst others about sys_audit.
- 2024-01-24 - Blog - Keeping your instance database footprint tidy (08): Maintain Email 
- 2024-01-09 - Blog - Keeping your instance database footprint tidy (07): Cleanup Shadow tables 
- 2023-11-29 - Blog - Keeping your instance database footprint tidy (06): Drop syslog_trans_prejakarta* tables

- 2023-11-13 - Blog - Keeping your instance database footprint tidy (05): Lower duration Table Rotation
- 2023-10-02 - Blog - Keeping your instance database footprint tidy (04): Reduce (over)Auditing

- 2023-08-01 - Blog - Keeping your instance database footprint tidy (03): Activating/adding Table cleaners 
- 2023-07-05 - Blog - Keeping your instance database footprint tidy (02): Maintain Attachments and Attachment Documents
- 2023-06-13 - Blog - Keeping your instance database footprint tidy (01): Maintain Audit Delete and Audit Relation

If Sys Audit is on Table extension (which you are seeing your question on shards), then do note if deleting on shards themselves:
https://www.linkedin.com/feed/update/urn:li:activity:7178718621982953472/

[JoelatNow]

@Mark Roethof - I'm liking your blogs; these two are access restricted. Would you refresh or enable?
- 2023-07-05 - Blog - Keeping your instance database footprint tidy (02): Maintain Attachments and Attachment Documents
- 2023-06-13 - Blog - Keeping your instance database footprint tidy (01): Maintain Audit Delete and Audit Relation