Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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/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.
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.

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 11.2.0.4

Tim... said...

Hi.

I've made a note of the fix in later versions.

Cheers

Tim...

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)