My Oracle Support Banner

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 later
Information 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


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