OPTIMIZER Patch vs fix_control (Doc ID 2989119.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

1. The customer met the following issue.

++ Bug 34857301 - SQL Failed With ORA-7445 [evapls()] (Doc ID 34857301.8)

2. Tried set "_fix_control" but failed.

SQL> alter system set "_FIX_CONTROL"="34857301:ON";
alter system set "_FIX_CONTROL"="34857301:ON"
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-02097: parameter cannot be modified because specified value is invalid

3. No rows returned from V$SYSTEM_FIX_CONTROL.

SQL> select * from V$SYSTEM_FIX_CONTROL
where bugno = 34857301 ;

no rows selected

Changes

Optimizer fixes are disabled by default. To enable the fix, set "_fix_control" = "bugno":ON or "_fix_control" = "bugno":1.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.