It’s been a while since I blogged about the DBMS_OPTIM_BUNDLE – and to me, the package is still sort of a mystery. Ideally you can least and enable or disable behavior changing optimizer fixes per RU. And in Oracle 19.10.0, you will find a new surprise. So You may need a one-off for DBMS_OPTIM_BUNDLE in 19.10.0.
Just in case you haven’t dealt with DBMS_OPTIM_BUNDLE yet or for a while, a quick recap.
With this procedure, you can list the available patches to turn on or off at will:
SQL> set serveroutput… Continue reading...