CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

UBE Performanace Issue 9.2 - Sporadically

edited Aug 14, 2018 5:02AM in CNC, DB and Operating System - JDE1 (MOSC) 5 commentsAnswered

We are facing an issue with a specific custom ube where the run times would widely fluctuate between couple of minutes to hours. There is no difference between the processing options and data selections of these 2 runs and they are mostly a resubmit of the same UBE by the user. But what would usually take 20 mins would countinue to run till 6-7 hours sometimes. Another version of the same UBE which usually takes 3-4 mins would run down to 20-25 mins sometimes. So almost a 7 fold increase in processing times happening sporadically.

We are currently in the middle of an upgrade and this is a 9.2 (TR 9.2.2.4) system which users are testing. The server is an AS400 server with V7R3 and is currently on the same host as our current production, just different partition. So resource consumption should not be an issue as far as I think and moreover there are not much users currently on the system. I have been monitoring the CPU during the time job runs and have not noticed any spikes.

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