RE: aud$ purge script

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Fri, 9 Aug 2013 14:21:02 -0700
Message-ID: <BLU165-W20C855C3E073E604480E44EB580_at_phx.gbl>

From the documentation on DBMS_AUDIT_MGMT:

The DB_DELETE_BATCH_SIZE property enables you to control the number of audit records that are deleted in one batch. Setting a large value for this parameter requires increased allocation for the undo log space.

Tim Gorman might say that the fastest DELETE is DROP TABLE or TRUNCATE TABLE.

Iggy

> http://www.oradba.ch/2011/02/manage-audit-trails-with-dbms_audit_mgmt/

>> 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

>> 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 --

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 09 2013 - 23:21:02 CEST