Data Guard, Easy Connect and the Observer for multiple configurations
EZConnect One of the challenges of automation in bin Oracle Environments is dealing with tnsnames.ora files. These files might grow big and are sometimes hard to distribute/maintain properly. The worst is when manual modifications are needed: manual operations, if not made carefully, can screw up…
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…