Apabila Anda ingin mengaktifkan proses parallel, sudahkah Anda mengetahui program apa saja yg akan mendapatkan benefit-nya? Kalau ada, dan sudah Anda test, go ahead..
Pada point ke-dua email saya sebelumnya, saya menekankan pentingnya melakukan benchmark antara program yg berjalan parallel dan serial, sehingga apa yg Anda lakukan terukur. regards, tomi --- Ujang Jaenudin <[EMAIL PROTECTED]> wrote: > ----- Original Message ----- > From: "Tomi Wijanto" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Monday, March 13, 2006 9:18 AM > Subject: Re: [indo-oracle] bagaimana cara manage db > oracle di server yang > dual procesor > > > > Proses Parallel adalah fitur yg bagus di Oracle, > > karena database secara otomatis melakukan > pembagian > > kerja tanpa perlu intervensi dari kita. > > Tetapi kita juga perlu hati-hati agar bisa > memakainya > > secara efektif. > > > > Ketika Anda cuma punya 2 CPU, mesti lebih hati2 > lagi. > > Hal2 ini mungkin bisa dipertimbangkan: > > - kalau proses parallel jalan pada waktu normal > (ada > > user lain yg memakai db), maka kemungkinan akan > > mengganggu availability dari resource utk user > lain > > tsb, karena kedua cpu dipakai. > > pak tomi, > > dengan keadaan server ini yang "super idle", apakah > dgn parallel nya > diaktifkan masih juga tidak direkomendasi? > pls advice.... > > sar -U 0 -f /var/log/sa/sa13 > CPU %user %nice > %system %idle > 08:01:00 AM 0 0.09 0.00 0.06 > 99.85 > 08:11:00 AM 0 0.17 0.00 0.04 > 99.79 > 08:21:00 AM 0 0.14 0.00 0.06 > 99.80 > 08:31:00 AM 0 0.28 0.00 0.10 > 99.63 > 08:41:00 AM 0 2.93 0.00 5.21 > 91.86 > 08:51:00 AM 0 4.95 0.00 9.62 > 85.43 > 09:01:00 AM 0 3.92 0.00 7.96 > 88.11 > 09:11:00 AM 0 0.44 0.00 0.11 > 99.45 > 09:21:00 AM 0 0.07 0.00 0.01 > 99.93 > 09:31:00 AM 0 0.51 0.00 0.16 > 99.33 > 09:41:00 AM 0 0.10 0.00 0.06 > 99.84 > 09:51:00 AM 0 0.05 0.00 0.02 > 99.93 > 10:01:00 AM 0 0.21 0.00 0.05 > 99.74 > 10:11:00 AM 0 0.66 0.00 0.28 > 99.06 > > sar -U 0 -f /var/log/sa/sa13 > CPU %user %nice > %system %idle > 08:01:00 AM 1 0.07 0.00 0.03 > 99.89 > 08:11:00 AM 1 0.14 0.00 0.03 > 99.83 > 08:21:00 AM 1 0.17 0.00 0.02 > 99.81 > 08:31:00 AM 1 0.29 0.00 0.08 > 99.63 > 08:41:00 AM 1 7.07 0.00 3.96 > 88.98 > 08:51:00 AM 1 12.70 0.00 7.45 > 79.85 > 09:01:00 AM 1 10.25 0.00 6.10 > 83.65 > 09:11:00 AM 1 0.45 0.00 0.07 > 99.49 > 09:21:00 AM 1 0.02 0.00 0.01 > 99.97 > 09:31:00 AM 1 0.37 0.00 0.14 > 99.49 > 09:41:00 AM 1 0.10 0.00 0.02 > 99.88 > 09:51:00 AM 1 0.02 0.00 0.00 > 99.98 > 10:01:00 AM 1 0.07 0.00 0.04 > 99.89 > 10:11:00 AM 1 0.28 0.00 0.25 > 99.47 > > > [EMAIL PROTECTED] sa]# cat /proc/meminfo > total: used: free: shared: buffers: > cached: > Mem: 1053007872 1049706496 3301376 0 > 96399360 783011840 > Swap: 2146529280 451444736 1695084544 > MemTotal: 1028328 kB > MemFree: 3224 kB > MemShared: 0 kB > Buffers: 94140 kB > Cached: 764660 kB > Active: 466532 kB > Inact_dirty: 370436 kB > Inact_clean: 21832 kB > Inact_target: 92 kB > HighTotal: 130976 kB > HighFree: 1088 kB > LowTotal: 897352 kB > LowFree: 2136 kB > SwapTotal: 2096220 kB > SwapFree: 1655356 kB > > > [EMAIL PROTECTED] sa]# free > total used free shared > buffers cached > Mem: 1028328 1025148 3180 0 > 94140 764708 > -/+ buffers/cache: 166300 862028 > Swap: 2096220 440856 1655364 > > > [EMAIL PROTECTED] sa]# iostat > Linux 2.4.2-2smp (localhost.localdomain) > 03/13/2006 > > avg-cpu: %user %nice %sys %idle > 0.37 0.00 0.04 0.71 > Device: tps Blk_read/s Blk_wrtn/s > Blk_read Blk_wrtn > dev2-0 0.00 0.00 0.00 > 16 0 > dev8-0 2.38 5.24 6.20 > 26150432 159800260 > > > regards > > --ujang > http://blog.faaza.info > > > Send instant messages to your online friends > http://asia.messenger.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 > > > [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/
