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 -- //www.freelists.org/webpage/oracle-l
