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

On Feb 14, 2008 11:21 AM, Gerald Cunningham < gcunningham_at_proteus-technologies.com> wrote:

>
> This is a physical Data Guard implementation with 1 primary / 1 standby.
> Oracle 9.2.0.8 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
http://www.jlcomp.demon.co.uk/statspack_01.html

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

--
http://www.freelists.org/webpage/oracle-l