SYS.AUD$ のパージ

SYS.AUD$ のパージ方法について確認していたところ。

標準監査と統合監査は一度に消せるのか？

コマンドはこちら。

BEGIN
  DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
   AUDIT_TRAIL_TYPE           =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
   USE_LAST_ARCH_TIMESTAMP    =>  FALSE,
   CONTAINER                  =>  DBMS_AUDIT_MGMT.CONTAINER_CURRENT );
END;
/

 

リファレンスはマニュアル参照。

docs.oracle.com

AUDIT_TRAIL_TYPE はここらへん。

  -- Audit Trail types
  -- 
  AUDIT_TRAIL_AUD_STD           CONSTANT NUMBER := 1;
  AUDIT_TRAIL_FGA_STD           CONSTANT NUMBER := 2;
  --
  -- Both AUDIT_TRAIL_AUD_STD and AUDIT_TRAIL_FGA_STD
  AUDIT_TRAIL_DB_STD            CONSTANT NUMBER := 3;
  --
  AUDIT_TRAIL_OS                CONSTANT NUMBER := 4;
  AUDIT_TRAIL_XML               CONSTANT NUMBER := 8;
  --
  -- Both AUDIT_TRAIL_OS and AUDIT_TRAIL_XML
  AUDIT_TRAIL_FILES             CONSTANT NUMBER := 12;
  --
  -- All above audit trail types
  AUDIT_TRAIL_ALL               CONSTANT NUMBER := 15;

  --
  -- OS Audit File Configuration parameters
  OS_FILE_MAX_SIZE              CONSTANT NUMBER := 16;
  OS_FILE_MAX_AGE               CONSTANT NUMBER := 17;

  -- 
  -- 
  CLEAN_UP_INTERVAL             CONSTANT NUMBER := 21;
  DB_AUDIT_TABLEPSACE           CONSTANT NUMBER := 22;
  DB_DELETE_BATCH_SIZE          CONSTANT NUMBER := 23;
  TRACE_LEVEL                   CONSTANT NUMBER := 24;
  -- AUD_TAB_MOVEMENT_FLAG(23) will not be entered in DAM_CONFIG_PARAM$
  AUD_TAB_MOVEMENT_FLAG         CONSTANT NUMBER := 25;
  FILE_DELETE_BATCH_SIZE        CONSTANT NUMBER := 26;

  --
  -- Values for PURGE_JOB_STATUS
  PURGE_JOB_ENABLE              CONSTANT NUMBER := 31;
  PURGE_JOB_DISABLE             CONSTANT NUMBER := 32;

  --
  -- NG Audit Trail write mode configuration
  AUDIT_TRAIL_WRITE_MODE        CONSTANT NUMBER := 33;
  -- Values for Write mode 
  AUDIT_TRAIL_QUEUED_WRITE      CONSTANT NUMBER := 1;
  AUDIT_TRAIL_IMMEDIATE_WRITE   CONSTANT NUMBER := 2;
  --AUDIT_TRAIL_COMMIT_WRITE      CONSTANT NUMBER := 3;

  --
  -- Values for TRACE_LEVEL
  TRACE_LEVEL_DEBUG             CONSTANT PLS_INTEGER := 1;
  TRACE_LEVEL_ERROR             CONSTANT PLS_INTEGER := 2;

  -- UNIFIED Audit Trail
  AUDIT_TRAIL_UNIFIED           CONSTANT NUMBER := 51;
  
  -- Enh 33171070: constants corresponding to new audit trail sources
  AUDIT_TRAIL_UNIFIED_TABLE     CONSTANT NUMBER := 52;
  AUDIT_TRAIL_UNIFIED_FILES     CONSTANT NUMBER := 53;