_wait_for_sync basically meant that a session is waiting for the sync of the
redo by the lgwr. Normally the redo log writer writes to disk and then
notifies the session that the transaction is completed. By setting this to
false, you no longer wait for the redo to go to disk.
That has no impact on
Hi!
I've sometimes used setting _wait_for_sync=false during Apps upgrade
projects, to upgrade performance. (As long as your database doesn't crash
during the parameter is set to false, no problems should occur).
I just started wondering, what would be the case if a parallel query starts
during so
