Performance degradation after upgrading Oracle database from 11g to 12c for documentum applications

Originally posted on https://newwayofcontentmanagement.blogspot.com/2019/06/performance-degradation-after-upgrading.html

I faced major performance issues when I upgrade database environment for one of the system from 11g to12c (12.1.0.2.0). Front end application is Document D2.

Here is my analysis -

In Oracle 12.1 the adaptive optimizer features are controlled by the OPTIMIZER_ADAPTIVE_FEATURES parameter, which…