Re: gcs log flush sync
From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 9 Oct 2008 15:18:12 -0700
Message-ID: <3b0f44a10810091518j63c44d14gd130a95b4ae81c3e@mail.gmail.com>
Date: Thu, 9 Oct 2008 15:18:12 -0700
Message-ID: <3b0f44a10810091518j63c44d14gd130a95b4ae81c3e@mail.gmail.com>
John,
I don't discount this as an idle wait. Basically you (LMS) are/is waiting for LGWR to flush the pending redo during CR fabrication. Without going too much in to details, you can turn off the behaviour by setting _cr_server_log_flush to false.
Are you looking for the details on this wait event or having a performance problem and suspecting the wait?
On Thu, Oct 9, 2008 at 12:22 PM, John D Parker <orclwzrd_at_yahoo.com> wrote:
> Anyone have any solid information on this wait event? The 10.2 docs indicate
> it's an idle event, but it's name is far too ominous to just be an idle
> event of the same pedigree as null event...
>
> Thanks,
> John
>
> PS. I'm seeing it on a 6 way 10.2.0.4 RAC on RHEL ES 4
>
>
-- Best Regards, K Gopalakrishnan Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ Author: Oracle Database 10g RAC Handbook, Oracle Press 2006 http://www.amazon.com/gp/product/007146509X/ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 09 2008 - 17:18:12 CDT