Comments
| 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/filesIt 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. Cheers Roni. |
JJ_MAD said... So impressive, thanks. |
Freek said... In 11.2.0.2 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.Cheers Tim... |
Willem said... Awesomely explained! Thanks for a helpful article. |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!