Hemant K Chitale wrote:Hemant, cheers,
aah. I see that some information has been deleted now.
I hope that you have found a resolution.
Hemant K Chitale
What is the server CPU utilisation (I'm not asking about DB CPU time but CPU consumed by non-Oracle processes on the same server) ?is that it is also known 'log file sync wait' time has multiple components. Part of it is about LGWR actually writing the redo to disk. Part of it is about LGWR collecting the redo. And part of it is about LGWR "posting" back to the waiting sessions that the write (sync) has been completed.