CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

standard query generates big log file sync waits at the database level

edited Oct 22, 2013 1:15PM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered
 Hello everyoneWe are using jde edwards 9.1 on oracle database standard edition 11.2.0.3
We are having problems in our database due to "log file sync wait events" and when i drill into the wait event i get the following query most of the time

SELECT PRODCTL.F0002.*, ROWID
FROM PRODCTL.F0002
WHERE ( NNSY = :KEY1 ) ORDER BY NNSY ASC FOR UPDATE OF NNN001, NNN002, NNN003, NNN004, NNN005, NNN006, NNN007, NNN008, NNN009, NNN010


I have asked the developers where this query is located and they have indicated me that this query belongs to the R42522 report, and therefore it is a standard.

I would like to know if anyone else has experienced this problem and if there is a way to solve it, and if in fact that query is a standard code because of the "for update" part.

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