Check if SQL Profile will be used

Hi,

following performance issue.

Oracle DB 12.1.0.2 + latest PatchSet

We did a migration of the Production DB and afterwards we have trouble with a few queries.

What have we done in general on the 12.1.0.2 database. We set parameter  adaptive_feature to FALSE.

We have some test queries

                    optimizer_feature_enable

Query           11.2.0.4           12.1.0.2

qy1               5 seconds        25 seconds         (runtime)

qy2               3 seconds         30-45 seconds

So we don't want to use optimizer_feature_enable in the future with 11.2.0.4 because is it dangerous and makes no sense.

(MOS Note 1362332.1 explains it)

The application is from a vendor so we are not able to easily change or rewrite the query.