Oracle optimizer issue for Windows based installations

In some Windows environments an issue has been reported with the Oracle optimizer. Suddenly a connection breaks within an Oracle session and may thereby cause unexpected behavior.

Generally the error may occur if very complex SQL statements have to be processed internally. The error scenario itself, however, is not characterized by a specific Oracle error code.

For avoiding this issue in a Windows environment, use the following workaround, which activates old optimizer behavior that has been tested as reliable:

SQL> alter system set OPTIMIZER_FEATURES_ENABLE=’9.2.0.8’ scope=spfile;