Performance issue after upgrade
Hi All,
We have done an oracle upgrade to 12cr1 from 11gr2 , during perf testing we identified the following parameters has been set at the database level to fix various perf issues,
ALTER SYSTEM SET OPTIMIZER_ADAPTIVE_FEATURES=false scope=both;
ALTER SYSTEM SET OPTIMIZER_DYNAMIC_SAMPLING=0 scope=both;
ALTER SYSTEM SET "_fix_control"='12914055:Off' scope=both;
Now that we have upgraded our peoplesoft application (9.2) & tools 8.55 ,the apps global setting has low level stats set at 1% and high level is at 100%,
Everytime the batch processes is around temp tables the stats are not efficient leading to perf issue as it is only 1% gathered,