purging for auditing

[Roshan]

Hello Erman,

trust you are fine.

I have setup purging for auditing on a production database. I have noticed the elapsed time for the audit job was greater for the audit job and users could not connect to db.

When I checked the alert log, I saw system tablespace was full
systemtbs.PNG


I followed the purging steps from

https://blog.dbi-services.com/purging-unified-audit-trail-in-12cr1/



Can you please advise how I can prevent the tablespace from being full and prevent performance issues?

Regards,
Roshan

[ErmanArslansOracleBlog]

Your SYSTEM tablespace is probably becoming full because of your audit data.
You may be auditing lots of stuff. So it depends on the things you audit..

Why don't you move the audit tables to a new-dedicated tablespace?

How To Move The DB Audit Trails To A New Tablespace Using DBMS_AUDIT_MGMT? (Doc ID 1328239.1)

[ErmanArslansOracleBlog]

Also have a look at the following document for purging:

SCRIPT: Basic example to manage AUD$ table in 11.2 with dbms_audit_mgmt (Doc ID 1362997.1)
In this node, you will find a script that for re-locating AUD$ and setting up a purge job..
But understand it first, then test it before taking it to LIVE.

[Roshan]

Thanks Erman