Auditing

AWS re:Invent day 2: All about Lakes

As usual the day 2 with Adams Selipsky’s keynote is where most announcements are done…and they have been severals. As you will probably see plenty of articles about these, and by the way I recommend you to take few(…)

From Oracle Standard Auditing to Oracle Unified Auditing

In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in(…)

Purging Unified Audit Trail in 12cR2

By Franck Pachot . A good thing from 12.2 is that the implementation of Unified Audit Trail has changed a little. It was stored in a weird CLI_SWP$ table but now we have a normal partitioned table named AUD$UNIFIED. In(…)

Purging Unified Audit Trail in 12cR1

By Franck Pachot . When you want to empty a table you have two methods: delete and truncate. If, for any reason (see previous post) the Unified Audit Trail has become too big, you cannot directly delete or truncate(…)

12c Unified Auditing and AUDIT_TRAIL=DB in mixed mode

By Franck Pachot . Oracle enables some auditing by default, and if you don't do anything, the tables where it is stored will grow in SYSAUX. Don't wait to get an alert when it is too late. Everything that fills(…)