My Oracle Support Banner

E1: UBE: UBE Running Slow In One Environment (Doc ID 2376346.1)

Last updated on MARCH 20, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Specific UBE running slow in production environment for all Versions and the same UBE and version works fine in the test environment.

Per the JDEDEbug the bottle neck is at specific Select Statement. This step take 5 seconds in Test and more that 4 minutes in Production.

Mar 09 16:10:49.119001 - 9536/8560 SELECT T0.GLKCO, T0.GLDCT, T0.GLDOC, T0.GLDGJ, T0.GLJELN, T0.GLEXTL, T0.GLPOST, T0.GLICU, T0.GLICUT, T0.GLDICJ, T0.GLCO, T0.GLANI, T0.GLAID, T0.GLMCU, T0.GLOBJ, T0.GLSUB, T0.GLSBL, T0.GLSBLT, T0.GLLT, T0.GLPN, T0.GLCTRY, T0.GLFY, T0.GLAA, T0.GLU, T0.GLUM, T0.GLRE, T0.GLEXA, T0.GLEXR, T0.GLR1, T0.GLAN8, T0.GLCN, T0.GLDKJ, T0.GLASID, T0.GLBRE, T0.GLVINV, T0.GLIVD, T0.GLPO, T0.GLPSFX, T0.GLDCTO, T0.GLLNID, T0.GLUSER, T0.GLPID, T0.GLJOBN, T0.GLUPMJ, T0.GLUPMT, T1.GMAID, T1.GMDL01, T2.MCMCU, T2.MCRP12 FROM JDE_PRODUCTION.PRODDTA.F0911 T0 WITH (NOLOCK) ,JDE_PRODUCTION.PRODDTA.F0901 T1 WITH (NOLOCK) ,JDE_PRODUCTION.PRODDTA.F0006 T2 WITH (NOLOCK) WHERE ( ( T0.GLOBJ BETWEEN '6300' AND '8250' AND T0.GLMCU IN ( ' 5025',' 5030' ) ) AND ( T0.GLPN = 1.000000 AND T0.GLFY = 17.000000 AND T0.GLLT = 'AA' ) ) AND ( T0.GLAID = T1.GMAID AND T0.GLMCU = T2.MCMCU ) ORDER BY T0.GLCO ASC,T1.GMDL01 ASC,T0.GLMCU ASC,T0.GLDGJ ASC

The same SQL query takes similar time to return the results even running directly in DB using SQL.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.