high log file sync wait

From: Suya <suya.huang_at_gmail.com>
Date: Mon, 26 Nov 2012 14:36:11 +0800
Message-ID: <CAJ-jFMYr9S2-F65LCGwkiQKjQQBWT_zxhAL_nPiRhqYe0fqoqQ_at_mail.gmail.com>

I have a four-node RAC system, the workload runs against the database waits on log file sync heavily, average wait time is 82.41 ms, account for 75% DB time. The system CPU resource is rich enough, average 70% idle time.

similar testing was done previously, which has log file sync wait with average 40 ms, and because the CPU resource shortage, this time, we added two logical CPU to the system. but see that the log file sync wait event was even worse.

any ideas on what else I should check in the AWR report?


Received on Mon Nov 26 2012 - 07:36:11 CET

Original text of this message