LOG FILE SYNC wait event

Hi All,

We are having a lot of Log file sync waits because of frequent commits
issued from the third party application. What are the solutions to fix this
apart from the follwing one...

> To move the redo logs to faster disks(Not feasible in our case).

We are using AUTO SGA (10g R2) which can tune log buffer on its own(Please
correct me if I am wrong).


Oracle DBA

Other related posts: