|Auditing Enhancements (DBMS_AUDIT_MGMT) in Oracle Database 11g Release 2 - Oracle 11gR2 allows better management of the audit trail using the DBMS_AUDIT_MGMT package.|
Lesio said...Cool :)
Bingo said...Great :)
K.DBA said...USE_LAST_ARCH_TIMESTAMP: Set to FALSE to purge all records/files
It is worth noting that it doesn't delete all of them, it takes into account the time period set in DEFAULT_CLEANUP_INTERVAL in DBMS_AUDIT_MGMT.INIT_CLEANUP. It seems to assume that anything before this time will have already been cleaned up.
Roni Vered said...Thanks a lot,
Very useful article about Auditing.
JJ_MAD said...So impressive, thanks.
Freek said...In 220.127.116.11 it seems that the aud$ table is realy moved to the sysaux tablespace by the init_cleanup procedure.
"sometimes" it takes Oracle multiple versions before getting a feature right
Jim said...Nice article. One minor point. You can move both the AUD$ and FGA_LOG$ tables to the newly created audit tablespace at the same time by defining the audit_trail_type as 'DBMS_AUDIT_MGMT.audit_trail_db_std' in lieu of 'DBMS_AUDIT_MGMT.audit_trail_aud_std' or 'DBMS_AUDIT_MGMT.audit_trail_fga_std'.
Tim... said...Jim: I know. The point was to show the variety of options available. If you look at the example, I do move them both at the same time when I am moving them back. I show all three variants.
Willem said...Awesomely explained! Thanks for a helpful article.
Wayne said...Want to confirm what Freek said. They have fixed the init_cleanup procedure. The first time you run it, it DOES move the AUD$ table to SYSAUX, if it is still in the SYSTEM tablespace. I'm running 18.104.22.168
I've made a note of the fix in later versions.