869578 wrote:I think this used to be true a long time in the past - possibly up to v7, with two variants on what was scanned.
One thing I suspect is about the number of dedicated server processes.
I have too much processes (about 6000), compared to the number of active session.
As far as I know, when a commit occurs, oracle must scan data structures of all dedicated server processes,
because redo entries must be flushed to redo log file in the order of SCN.
(not sure, I have read it long ago, but forgot .. )
Reducing the number of processes could help to reduce "log file sync" wait?The question is ambiguous. If you mean just the parameter processes, then this will have no different.