query executing often and generating big sequential reads on the database
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
0