performance issues in 12.1.0.2

[satish]

Dear Erman,

We are using EBS R12.2.5 with database version 12.1.0.2.Recently we found a sql which has created 11 child cursors.We have verified and found the reason is due to query reoptimisation with use_feedbacks='Y'.

Can we disable optimiser_adaptive_features in 12.1.0.2 without applying any patches?

Thank you,
satish

[ErmanArslansOracleBlog]

For using Oracle DB 12CR1 with EBS 12.2, "optimizer_adaptive_features" must be FALSE .. This is mandatory anyways.

Ref: Section 5: Release-Specific Database Initialization Parameters for Oracle 12c Release 1
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)