Hi,
Mungkin bisa coba menambah nilai SORT_AREA_SIZE and sebar disk I/O untuk temporary tablespace. Thanks --- In [email protected], "Sugondo Cahyadi Suwindra" <[EMAIL PROTECTED]> wrote: > 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/
