CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

query executing often and generating big sequential reads on the database

edited Feb 24, 2014 5:32PM in CNC, DB and Operating System - JDE1 (MOSC) 4 commentsAnswered

Hello everyoneWe have gone live with JDE 9.1 and we have noticed that the database is behaving diferently than it used to on JDE 812.

The thing is that the following query is executing all the time
SELECT T0.WBJPO,T0.WBUID,T0.WBOID,T0.WBLNGPREF,T0.WBJVER

FROM PD910.F989999 T0, PD910.F989998 T1

WHERE ((T1.WBJOBID = :1 AND T0.WBUID = :2 )) AND (T0.WBOID = T1.WBOID)
and everytime this query executes our database is showing big secuential reads at the database level.
Is this normale for jde to be reading this tables all the time, we have not deployed a package full lately but we would like to know why the reads from this table are causing I/O peaks at the database level and if there is a way to tune it

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