Login  Register

purging for auditing

Posted by Roshan on Dec 18, 2017; 7:24am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/purging-for-auditing-tp4703.html

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