Dari wait event Anda, tdk ada yg signifikan. Apakah pengambilan snapshot-nya dilakukan sebelum dan sesudah report dijalankan?
Kalau memang sudah demikian, coba diberikan informasi total cpu yg dipakai (dari Top 5 wait events di report statspack). Kalau benar yg signifikan adalah pemakaian CPU, maka coba diberikan informasi TOP SQL-nya (dari SQL ordered by Gets di report statspack). Tanpa tahu bagian mana yg problem, sulit memberikan solusi.. regards, tomi --- Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > dear all, > > user report aplikasi jalane letoy tenan euy..... > > ora9ir2.0.1 > redhat7.1 > ram 2.5gb > sga 1.5gb > buffer cache 512mb > large pool 608mb > shared pool 304mb > i/o raid 5 scsi > shared server, user +- 25, tapi session bisa >100 > > statspack: > > Snap Id Snap Time Sessions > Curs/Sess Comment > ------- ------------------ -------- > --------- ------------------- > Begin Snap: 1 17-Apr-06 > 09:34:30 68 24.6 > End Snap: 2 17-Apr-06 > 10:09:48 76 26.1 > Elapsed: 35.30 > (mins) > > Cache Sizes (end) > ~~~~~~~~~~~~~~~~~ > Buffer Cache: 512M Std > Block Size: 8K > Shared Pool Size: 304M Log > Buffer: 512K > > > > > Avg > > Total Wait wait Waits > Event Waits Timeouts > Time (s) (ms) /txn > ---------------------------- ------------ ---------- > ---------- ------ -------- > control file parallel write 731 0 > 15 20 4.5 > log file sync 150 0 > 1 9 0.9 > db file sequential read 166 0 > 1 4 1.0 > process startup 2 0 > 0 31 0.0 > latch free 6 2 > 0 7 0.0 > log buffer space 1 0 > 0 21 0.0 > SQL*Net more data to client 553 0 > 0 0 3.4 > control file sequential read 261 0 > 0 0 1.6 > SQL*Net break/reset to clien 13 0 > 0 1 0.1 > log file parallel write 607 607 > 0 0 3.7 > db file parallel write 268 134 > 0 0 1.7 > db file single write 16 0 > 0 0 0.1 > direct path read 68 0 > 0 0 0.4 > LGWR wait for redo copy 8 0 > 0 0 0.0 > direct path write 16 0 > 0 0 0.1 > enqueue 1 0 > 0 0 0.0 > virtual circuit status 40,609 13 > 2,166 53 250.7 > wakeup time manager 69 67 > 1,988 28814 0.4 > SQL*Net message from client 40,697 0 > 1,228 30 251.2 > SQL*Net message to client 40,700 0 > 0 0 251.2 > > ------------------------------------------------------------- > > pak bowo & pak tomi or yg laennya....suggesti nya > dong.... > > my thinking : > 1. musti di buatin disk berbeda utk tujuan berbeda ? > disk utk datafile, log file, ctl file musti > dipisahin? apa perlu async io? tapi rh71 support gak > ya async io? > 2. buatin dedicated server ? > 3. any other clues? > > > regards > > --ujang > > [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.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ 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.lizt.org (NEW) ----------------------------------------------- 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/
