Skip to content

AUD$

Cleanup Audit Trail – the Full Picture

Oracle Database 23ai introduces several enhancements to unified auditing, focused on flexibility, and effectiveness. Some of the new key features are: Desupport of Traditional Auditing: Traditional auditing is desupported in Oracle 23ai, which means all auditing must now be done using unified auditing. Unified auditing consolidates audit records into a single, secure trail and supports conditional policies for selective auditing.… 

Oracle 11g R2: catupgrd.sql running for hours

During the last weeks, I was confronted to an uncommon bug during the database upgrade from security sensibledatabases.

The upgrade was sticking for hours on the script c1101000.sql.  which tried to fill the column DBID with the database DBID of the tables AUD$ and/or FGA_LOG$.