Re: log file sync waits / slow response time at log switches

From: Jared Still <>
Date: Sat, 16 Feb 2008 19:57:39 -0800
Message-ID: <>

On Feb 14, 2008 11:21 AM, Gerald Cunningham <> wrote:

> This is a physical Data Guard implementation with 1 primary / 1 standby.
> Oracle 64-bit on Solaris.
> From the alert log, it appears that Oracle is waiting until the redo
> information has been written to the standby site
> before it switches the primary's redo logs.
> log_archive_dest_3 was set to mandatory, so I tried setting it to optional
> (see line "c" below). This didn't appear to
> have any effect. Here is an excerpt of my primary alert log:

Re the logfile sync waits, see

You may be hitting a 9.x bug that obscures the cause of the wait.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Sat Feb 16 2008 - 21:57:39 CST

Original text of this message