Set OPTIMIZER_FEATURES_ENABLE to a lower version.

==========

Issue

==========

Workaround for new oracle version optimizer bug.

Setting OPTIMIZER_FEATURES_ENABLE to a lower version.

==========

Example

==========

SELECT name, value 

  FROM V$PARAMETER 

 WHERE name LIKE '%optimizer_features_enable%'

NAME                           VALUE
------------------------------ ------------------------------
optimizer_features_enable      19.1.0
 
ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE='12.1.0.2' SCOPE=BOTH;

SELECT name, value 

  FROM V$PARAMETER 

 WHERE name LIKE '%optimizer_features_enable%'

NAME                           VALUE
------------------------------ ------------------------------
optimizer_features_enable      12.1.0.2