----- 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
<*> 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/
