Re: aud$ purge script
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: gardiner9@xxxxxxxxx
- Date: Fri, 9 Aug 2013 21:24:59 +0100
Hi,
Be aware of license -
http://www.oradba.ch/2011/02/manage-audit-trails-with-dbms_audit_mgmt/
regards,
Marcin
On Fri, Aug 9, 2013 at 5:55 PM, Steve Gardiner <gardiner9@xxxxxxxxx> wrote:
> Naga,
> I've used the info in this pythian blog with great success at various sites
> to purge the audit table.
>
> http://www.pythian.com/news/1106/oracle-11g-audit-enabled-by-default-but-what-about-purging/
> It creates a procedure and a scheduled job to purge the audit log. It even
> writes a message to the alert log with it's status.
>
> I would also suggest moving sys.aud$ to be stored in a tablespace other
> than system. 11g has a package to do this.
> These are the commands to move the sys.aud$ table from the system
> tablespace to the sysaux tablespace:
>
> As sys
> BEGIN
> DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(audit_trail_type =>
> DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
> audit_trail_location_value => 'SYSAUX');
> END;
> /
>
> Be careful how much data you will purge the first time. Purge the data
> first then move to a new tablespace.
>
>
> Steve Gardiner
> gardiner9@xxxxxxxxx
>
>
>
> Original Message:
> Date: Fri, 9 Aug 2013 10:24:22 +0530
> Subject: aud$ purge script
> From: Nagaraj S <nagaraj.chk@xxxxxxxxx>
>
> Hello Gurus,
> I have a task to purge aud$ table and it need to done in automated way
> on every month. Please help on sharing the purge script to schedule in db
> scheduler
>
> -Naga
>
> --
>
> Steve Gardiner
> gardiner9@xxxxxxxxx
>
> This Day in Computer History
> http://www.computerhistory.org/tdih/
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
