Silent ORA-904 on MERGE

From time to time looking at the tkprof’ed SQL traces I see this message: A some_predicate_here is the predicate from ON clause of a MERGE statement executed by the session. Up until recently I didn’t know why that happens, and since the error is not reported to the end-user there’s no big problem other than [...]

OPT_PARAM and OPTIMIZER_FEATURES_ENABLE

Here’s a question appeared on the oracle-l mailing list recently: Does anyone know if opt_param hint works with optimizer_features_enable in 11.1.0.7?