RE: Audit Purge Script
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <martin.a.berger@xxxxxxxxx>
- 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>
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx]
Sent: Friday, March 30, 2012 2:10 PM
To: Patterson, Joel
Cc: nagaraj.chk@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Audit Purge Script
Joel,
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' :)
Martin
On Fri, Mar 30, 2012 at 19:32, <Joel.Patterson@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Martin Berger
> Sent: Friday, March 30, 2012 3:13 AM
> To: nagaraj.chk@xxxxxxxxx
> 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.
>
> hth,
> Martin
>
> On Thu, Mar 29, 2012 at 22:45, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote:
>> Kindly give me steps that need to schedule Audit Purge Job for purging the
>> table SYS.AUD$ records more than 90 days
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
