_____________________________________________________________________________________

DBMS_AUDIT_MGMT:
http://docs.oracle.com/database/121/ARPLS/d_audit_mgmt.htm
_____________________________________________________________________________________
_____________________________________________________________________________________

/*********
* DEINIT *
*********/
BEGIN
DBMS_AUDIT_MGMT.DEINIT_CLEANUP(
              audit_trail_type   => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL);
END;
/

/*******
* INIT *
*******/
BEGIN
DBMS_AUDIT_MGMT.INIT_CLEANUP(
              audit_trail_type   => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
      default_cleanup_interval   => 336 /* hours */);
END;
/

/********
* CLEAN *
********/
BEGIN
   DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL (
      AUDIT_TRAIL_TYPE          => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
      USE_LAST_ARCH_TIMESTAMP   => FALSE);
END;
/

/********
* CHECK *
********/
set serveroutput on
BEGIN
 IF 
   DBMS_AUDIT_MGMT.IS_CLEANUP_INITIALIZED(DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD)
 THEN
   dbms_output.put_line ('yeah');
 ELSE
   dbms_output.put_line ('no');
 END IF;
END;
/


_____________________________________________________________________________________