log file sync wait event in 11gr1
In 11gr1 we are seeing the logfile sync wait event in top event of awr report. We have optimized the storage still we are finding the same. Nature of Application as every commit after one transaction complete. Also they doing the rollback's at the same time with ratio of 2:1 i.e in awr report we have seen, if we there is 1000 commit, its also have 500 rollbacks.
To reduce the log file sync wait event, One of consultant as advised us to reduce the log_buffer init parameter to 1mb from default i.e 25mb
From google i find that log_buffer used in older version of oracle to reduce the logsync wait event. My understand in 11g this parameter is auto takencare by oracle. By changing of parameter any useful or anyother way to optimize this wait event?
Appreciate your reply.