RE: Log file sync spike

  • From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 12 Jun 2006 08:48:16 -0000

    * From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>

*Over a period as long as fifteen minutes, it is
possible for a change in timing (two jobs running
concurrently instead of serially) to cause the redo
synch times (and log file sync waits) to change dramatically while the
redo write time doesn't
change at all.

Thank you, Jonathan.

"Dramatically" in my case is 10-15 times bigger wait time per period (I
take snapshots at 20 min intervals.)
I am just wondering where lays the cause for this behavour. I can only
speculate that the way LGWR batches log sync requests can cause a longer
wait times.

Brgds, Laimis N.


Other related posts: