hi .. anyone awake :) ?
i used exp and moved my db from oracle 10gr2 to 11gr2 .. there is just 1 database in the server and just 11 tables .. not that big tables .. Now the database starts to get slow .. via enterprize manager, i see commit/log file sync taking a significant amount of time. The commit is around 2400 per minute .. Nothing on the application side has changed .. the commit used to be 2000-2500 on 10gr2 also .. moving on 11gr2, it suddenly seems
the cause of the issue .. I googled a bit, read a few pdfs on the subject and based on that, tried to decrease the redo log group and increase size also, but that has not helped .. Is there anything that I can do to check/fix this issue ? The server is on raid 10 with 15krpm disks .. cannot add more disk or ssd
wow .. long :D