what would be its optimal valuesIf there were an optimal value for all cases, don't you think that Oracle would set it to that automatically?
Asadullah699 wrote:Some good links, Read Jonathan Lewis comments
os version is solaris 10
db version 22.214.171.124
how to tune log file sysnc waits in 11gr2 what parameters are involving in tuning log file sync and what would be its optimal values.
can you name some parameter name which is involve in tuning log file sync or tuning log files??As explained by other people, there is not parameter related to this. Do you have any performance problem which made you think "tuning" of this? Why do you want to "tune" this. How you came to know that this is the "problem"
Mohamed Houri wrote:Very good post from Riyaj, there.
In addition to the link supplied by CKPT, it is worth reading the following two posts on 'log file sync' waits tuning to get comprehensive understanding of that wait event