Broadcast on commit and log file sync
From: saurabh manroy <saurabhmanroy_at_gmail.com>
Date: Fri, 24 Feb 2012 10:56:53 +0100
Message-ID: <CAELkjfXxv+-a+DS5YKAvg2Xf5sLM0NK4-bga+0fs-ZRfXYXzAg_at_mail.gmail.com>
Hello All,
I am seeing the following message in lgwr tracefile along with 'log write time wait time' warnings:
Date: Fri, 24 Feb 2012 10:56:53 +0100
Message-ID: <CAELkjfXxv+-a+DS5YKAvg2Xf5sLM0NK4-bga+0fs-ZRfXYXzAg_at_mail.gmail.com>
Hello All,
I am seeing the following message in lgwr tracefile along with 'log write time wait time' warnings:
Warning: log write broadcast wait time 3000ms
This is a RAC database (Version 11.1.0.7.9) We are using default BOC SCN scheme.
My question is: In RAC, Can this wait time exacerbate problems of log file sync waits ? Any known conditions ?
There are few bugs (e.g. 7716356) on MOS pointing to increase in log file sync waits due to BOC scheme, but i am unable to draw a clear picture in my mind about the whole mechanism of BOC and how can it impact log file sync.
Any comments are welcome.
Regards,
Saurabh Manroy
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 24 2012 - 03:56:53 CST