OPTIMIZER Patch vs fix_control
(Doc ID 2989119.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |