DBMS_AUDIT_MGMT
We are using 10.2 database on linux & aix platforms.
I have set up auditing in the database by setting up following parameters
AUDIT_SYS_OPERATIONS=TRUE
AUDIT_TRAIL=DB
I have also moved aud$ to a dedicated tablespace as per Script to move SYS.AUD$ table out of SYSTEM tablespace [ID 1019377.6]
I have set up a purge job to purge audit records older than 30 days..below is the job
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'SYSTEM.AUDIT_SET_LAST_ARCHIVE_TS',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN '||
'SYS.DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, last_archive_time => systimestamp - interval ''30'' day); '||
I have set up auditing in the database by setting up following parameters
AUDIT_SYS_OPERATIONS=TRUE
AUDIT_TRAIL=DB
I have also moved aud$ to a dedicated tablespace as per Script to move SYS.AUD$ table out of SYSTEM tablespace [ID 1019377.6]
I have set up a purge job to purge audit records older than 30 days..below is the job
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'SYSTEM.AUDIT_SET_LAST_ARCHIVE_TS',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN '||
'SYS.DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, last_archive_time => systimestamp - interval ''30'' day); '||
0