Database Administration (MOSC)

MOSC Banner

Can we configure the start time of an audit purge job that's created by DBMS_AUDIT_MGMT?

edited Apr 27, 2018 6:07PM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi,

Use the following procedure DBMS_AUDIT_MGMT.CREATE_PURGE_JOB to create an automatic audit purge job. It only needs to specify the frequency of the job. The job runs for the first time right after the procedure is executed.

DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(

  audit_trail_type IN PLS_INTEGER,

  audit_trail_purge_interval IN PLS_INTEGER,

  audit_trail_purge_name IN VARCHAR2,

  use_last_arch_timestamp IN BOOLEAN DEFAULT TRUE,

  container IN PLS_INTEGER DEFAULT CONTAINER_CURRENT) ;

Is there a way to configure the time of the first execution ?

Thanks,

Iris

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center