Re: log file sync waits / slow response time at log switches
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: gcunningham@xxxxxxxxxxxxxxxxxxxxxxxx
- Date: Sat, 16 Feb 2008 19:57:39 -0800
On Feb 14, 2008 11:21 AM, Gerald Cunningham <
gcunningham@xxxxxxxxxxxxxxxxxxxxxxxx> 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
Other related posts:
