Install, Upgrades & Change Mgmt - JDE1 (MOSC)

MOSC Banner

Tools 9.2 Upgrade - Some UBEs much slower afterward upgrade

edited Jul 29, 2016 11:03AM in Install, Upgrades & Change Mgmt - JDE1 (MOSC) 16 commentsAnswered ✓

We recently went live with tools only upgrade to 9.2.0.3, and on our AIX ENT servers we are seeing dramatically slower processing for those UBEs which are CPU intensive.  A good example would be R097001, which went from 90-120 minutes to 10+ hours to process 27M records.  When we run the R097001 on a windows workstation, it takes a bit less than 120 minutes, which seems to let the database off the hook.  In what universe is it OK for a windows webdev machine to outperform a Power8 AIX box?  Database intensive jobs (which are most of them) are processing normally.  Looking back, we can now see that this is happening in all the lower environments, so we should have noticed this before going live, but we didn't and now we are scrambling.

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