Halo semua, Apa ada yang bisa kasih masukan tentang write complete waits? Saya punya kasus seperti berikut: - Aplikasi mengalami performance problem, dan kalau di trace terdapat cukup banyak WAIT pada Write Complete Waits - Seluruh Write Complete Waits pada trace file menunjuk ke temp files di temporary tablespace (db_files = 600) - Terjadi sesaat setelah transaksi berakhir: XCTEND rlbk=0, rd_only=0 WAIT #0: nam='latch free' ela= 4 p1=-4611686015813072640 p2=66 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=62903 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=62903 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=62903 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=62903 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=62905 p3=0 WAIT #0: nam='write complete waits' ela= 107 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 107 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 105 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 105 p1=609 p2=84343 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 105 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 109 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 112 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 105 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 107 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 104 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=84357 p3=0 WAIT #0: nam='write complete waits' ela= 109 p1=609 p2=69145 p3=0 WAIT #0: nam='write complete waits' ela= 103 p1=609 p2=69145 p3=0 WAIT #0: nam='write complete waits' ela= 105 p1=609 p2=69145 p3=0 Ada yang punya ide apa yang harus dilakukan? Tks, Dado
[Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
