Re: log file sync waits / slow response time at log switches
Date: Sat, 16 Feb 2008 19:57:39 -0800
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 22.214.171.124 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 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 16 2008 - 21:57:39 CST