How to get the Data Guard broker configuration from a SQL query?
Everybody knows that you can get the Data Guard configuration in dgmgrl with the command: show configuration; but few know that this information is actually available in x$drc: SQL> desc x$drc Name Null? Type ————— ——– ————— ADDR RAW(8) INDX NUMBER INST_ID NUMBER CON_ID NUMBER…
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