Sebelum tuning, perlu dipastikan dulu apakah log writer memang bermasalah? Misalkan wait event 'log file sync','log buffer space','log file switch completion' apabila dibandingkan dengan total pemakaian cpu, apakah cukup signifikan besarnya?
Masalah yg berhubungan dgn log writer biasanya karena ukuran log buffer terlalu kecil/besar, terlalu sering commit, ada bottleneck waktu menulis ke online redo log (i/o lambat). regards, tomi --- otaklucu <[EMAIL PROTECTED]> wrote: > all, salam... > saya mau tanya cara untuk tuning redo log writer. > saya > masih pake oracle 8.1.7. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
