Tag Archives: opt_param

OPT_PARAM Hint saves the day…

One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by this bug: Bug 14347248  ORA-600 [kkqjpdGetContext:1] parsing SQL with subquery The workaround in the bug suggested running this ALTER SESSION command. alter session set “_optimizer_unnest_disjunctive_subq”= FALSE; Rather than alter […]