standard query generates big log file sync waits at the database level
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.