Boleh tahu informasi mengenai online redo logfile nya? (Jumlah group, member dan size)
Soale, wait pada, control file & logfile-nya tinggi euy: penyebabnya, mungkin pada masalah checkpoint (?) control file parallel write 731 0 15 20 4.5 log file sync 150 0 1 9 0.9 SQL> SELECT group#, bytes, members FROM V$LOG; SQL> SHOW parameter log_checkpoint SQL> SHOW parameter mttr SQL> SELECT name FROM V$CONTROLFILE; Bowo --- In [email protected], Tomi Wijanto <[EMAIL PROTECTED]> wrote: > > 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/
