I haven't used this particular procedure, but based on how it is written, yes; if run as below, it should delete everything older than 90 days. That said, as I'm a bit uptight about what runs on prod, I'd always vote to test it - even just by running the proc manually - before scheduling it on any system important enough to keep 90days of audit logs. On Thu, Mar 29, 2012 at 3:25 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: > Thank You i got it. I use below procedure to schedule the job and my > understanding is > job_action => 'begin purge_audit_trail(90); end;', --> the purge will keep > only 90 days record. Plz correct me if i am wrong > ... -- //www.freelists.org/webpage/oracle-l