Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Performance issue after upgrade

edited May 22, 2017 5:00AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center