DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL not working on 12c? Here’s why…
It is bad to realize, after a few years, that my customer’s Audit Cleanup procedures are not working properly for every database… NOTE: The post is based on standard audit, not unified audit. My customer developed a quite nice procedure for database housekeeping (including diag…
BP and Patch 22652097: set optimizer_adaptive_statistics to FALSE explicitly or it might not work!
Update 14.03.2018: After some exchanges with Nigel Bayliss, the behaviour described here has been filed as unpublished bug 27626925: OPTIMIZER ADAPTIVE STATS DEFAULT FALSE NOT HONORED WHEN ENABLED IN OCT OR JAN BP. It will be fixed starting with April’s bundle patch. According to…
Social Media @trivadis