Re: Mirroring redo log groups or not ?

From: Rich <richa03@xxxxxxxxx>
To: cicciuxdba@xxxxxxxxx
Date: Tue, 7 Apr 2009 21:33:28 -0700

Back to the OP's question.

I think you mean "log file sync", right?

This means a session waits for LGWR to write redo to disk after commit or
rollback.
It is usually due to too many commits or short transactions; you should
commit in batch or use faster redo log disk IO.

However, we need more information.  This wait has numerous steps with even
more implications.

First off, what makes you think this is THE issue?

What are the following:
"redo write time" statistic
"log file parallel write" waits

Is the system otherwise busy during high numbers of this event?

It may not be as simple as just moving the redo logs to faster disks...

Follow-Ups:

RE: Mirroring redo log groups or not ?
From: Crisler, Jon

References:
- Re: database monitoring tools - what is your short list of
  - From: Yong Huang
- Re: Nasty RAC Bug in 10g. If you are running multi-nodes and one instance or more is not normally running - Read this...
  - From: Ravi Gaur
- Mirroring redo log groups or not ?
  - From: Crisler, Jon
- Re: Mirroring redo log groups or not ?
  - From: Rajeev Prabhakar
- RE: Mirroring redo log groups or not ?
  - From: Crisler, Jon
- Re: Mirroring redo log groups or not ?
  - From: David Barbour
- RE: Mirroring redo log groups or not ?
  - From: Mark W. Farnham
- RE: Mirroring redo log groups or not ?
  - From: Kenneth Naim
- RE: Mirroring redo log groups or not ?
  - From: Mark W. Farnham
- Re: Mirroring redo log groups or not ?
  - From: Guillermo Alan Bort

Re: Mirroring redo log groups or not ?

Other related posts: