RE: Audit Purge Script
Date: Fri, 30 Mar 2012 14:14:04 -0400
Am I loosing something here by not using the dbms_audit_mgmt package over deleting from sys.aud$ directly? The adump records are managed by a cleanup script that works in all the dump dirs for 10g, and 11g keeps one year by default if I am not mistaken.
So given the choice between the two, I have to be missing something or there would be no reason to go through all that and move the data to a new tablespace to boot>
From: Martin Berger [mailto:martin.a.berger_at_gmail.com] Sent: Friday, March 30, 2012 2:10 PM
To: Patterson, Joel
Cc: nagaraj.chk_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Audit Purge Script
you are right, it's not easy.
Maybe it helps to understand: It's a spin off from Audit Vault, after some iterations and requests Oracle decided to make it available for non-Audit-Vault customers as well.
In my current situation it's quite convenient to implement it at every new created DB - so audit is in place 'just in case' :)
On Fri, Mar 30, 2012 at 19:32, <Joel.Patterson_at_crowley.com> wrote:
> The problem I had to wrestle with when considering dbms_audit_mgmt was that the audit table needs to be moved to an entirely new tablespace... which I believe comes with upgrade details.
> I kathryn's script works and does the job just as good, it certainly is easier. All the code in this doc ID seems to be an awful lot when compared scheduling this simple script.
> Joel Patterson
> Database Administrator
> 904 727-2546
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Berger
> Sent: Friday, March 30, 2012 3:13 AM
> To: nagaraj.chk_at_gmail.com
> Cc: oracle-l
> Subject: Re: Audit Purge Script
> maybe you want to read
> SCRIPT: Basic example to manage AUD$ table in 11.2 with
> dbms_audit_mgmt [ID 1362997.1]
> in MetaLink.
> On Thu, Mar 29, 2012 at 22:45, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
>> Kindly give me steps that need to schedule Audit Purge Job for purging the
>> table SYS.AUD$ records more than 90 days