From: Rebstock, Roland (Roland.Rebstock@usi.net)
Date: Tue Nov 18 2003 - 09:10:25 EST
All, I have a E4500 running Solaris 7 with Oracle 9i. The server has 8
cpu's and 8GB of ram. Looking at the stats below the server seems idle
but im trying to get a understanding of why all the physical memory is
being allocated. It seems that Oracle which is fairly idle as well has
allocated all the physical memory which makes the server from a Trending
view seeming to be in need of additional memory. The swap utilization
is low, 1GB used out of 11GB and the server is not scanning at all.
Whats a good definition on the appearance of the physical memory
allocation? There are about 29 Oracle Processes running that have 700K
in resident memory. Im interested "Does this server need more memory or
is SOP? We have about 300 Oracle server in the environment and this one
seems to be the only one that appears to have all the memory allocated?
Checking CPU I/O statistics...
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
0 34 0 430 103 100 533 2 13 54 0 192 6 8 0
86
1 66 0 982 1401 1399 197 2 11 35 0 344 15 5 0
79
4 36 0 518 134 131 446 2 13 48 0 209 7 7 0
85
5 36 0 543 106 102 534 2 14 54 0 224 8 8 0
84
8 30 0 448 103 100 476 2 13 51 0 190 6 8 0
86
9 53 0 439 160 157 426 7 15 66 0 285 6 5 0
89
12 52 0 334 159 157 369 6 15 60 0 253 4 4 0
92
13 49 0 1672 402 200 272 2 12 32 0 305 16 5 0
79
CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt
idl
0 0 0 42 101 100 337 1 9 12 0 34 0 4 0
96
1 0 0 0 1679 1678 59 1 5 21 0 31 0 1 0
99
4 0 0 0 100 100 722 0 5 12 0 66 0 3 0
97
5 0 1 0 103 102 970 1 12 13 0 24 0 6 0
94
8 0 1 0 100 100 212 0 4 5 0 40 0 12 0
88
9 0 0 28 134 133 868 7 29 35 0 33 0 11 0
89
12 0 0 14 150 150 133 6 10 35 0 62 1 0 0
99
13 3 0 728 403 203 146 0 16 5 0 80 2 1 0
97
Checking memory statistics...
procs memory page disk faults
cpu
r b w swap free re mf pi po fr de sr s3 s4 s4 s5 in sy cs us
sy id
0 0 0 4552 12944 11 361 201 25 115 13352 15 0 1 0 1 4294967196 2006
688 8 6 85
0 0 0 10735864 143696 0 298 4 0 0 18720 0 0 1 0 1 2887 2135 3995 5
6 89
0 0 0 10735296 143208 0 311 8 0 0 23048 0 0 1 0 1 3239 2616 4673 4
6 90
0 0 0 10735296 143208 0 300 8 0 0 26568 0 0 17 0 17 3127 1383 4151 2
7 91
0 0 0 10734920 142832 0 301 0 0 0 21528 0 0 0 0 0 3011 2153 4177 2
6 93
Checking average wait for disk and network I/O...
Average number of jobs in the run queue over the last 1, 5 and 15
minutes
is: load average: 0.66, 0.62, 0.60
Top SnapShot
last pid: 4599; load averages: 0.66, 0.62, 0.60 09:03:20
65 processes: 63 sleeping, 2 on cpu
Memory: 8192M real, 140M free, 736M swap in use, 10G swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
4249 oracle 1 59 -20 703M 684M sleep 0:13 0.50% oracle
4589 oracle 1 59 -20 700M 679M cpu/9 0:00 0.26% oracle
4568 oracle 1 59 -20 700M 680M sleep 0:00 0.18% oracle
4599 root 1 5 0 1800K 1344K cpu/1 0:00 0.14% top
4564 oracle 1 59 -20 700M 679M sleep 0:00 0.12% oracle
4479 oracle 1 59 -20 701M 682M sleep 0:02 0.09% oracle
4591 oracle 1 59 -20 700M 679M sleep 0:00 0.05% oracle
139 oracle 1 60 -20 700M 675M sleep 32:42 0.02% oracle
162 oracle 1 59 -20 9480K 3096K sleep 39:58 0.02% tnslsnr
4204 root 1 58 0 5424K 2216K sleep 0:00 0.01% sshd
13 root 3 58 0 6528K 1248K sleep 16:55 0.01% vxconfigd
4574 root 1 35 0 1064K 960K sleep 0:00 0.00% performance
4598 root 1 35 0 968K 888K sleep 0:00 0.00% col
1 root 1 58 0 824K 160K sleep 20:03 0.00% init
504 root 1 58 0 4576K 1552K sleep 15:48 0.00%
sysedge.sol27-s
last pid: 4603; load averages: 0.64, 0.62, 0.60 09:03:25
66 processes: 64 sleeping, 2 on cpu
CPU states: 92.0% idle, 2.0% user, 6.1% kernel, 0.0% iowait, 0.0%
swap
Memory: 8192M real, 139M free, 737M swap in use, 10G swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
4249 oracle 1 59 -20 703M 684M sleep 0:14 0.52% oracle
4564 oracle 1 59 -20 701M 679M cpu/1 0:00 0.17% oracle
4568 oracle 1 59 -20 700M 680M sleep 0:00 0.14% oracle
4293 oracle 1 59 -20 700M 679M sleep 0:00 0.12% oracle
4599 root 1 50 0 2624K 1760K cpu/13 0:00 0.11% top
4479 oracle 1 59 -20 701M 682M sleep 0:02 0.08% oracle
4603 oracle 1 59 -20 700M 679M sleep 0:00 0.06% oracle
4601 oracle 1 59 -20 700M 679M sleep 0:00 0.06% oracle
4591 oracle 1 59 -20 700M 679M sleep 0:00 0.04% oracle
139 oracle 1 60 -20 700M 675M sleep 32:42 0.02% oracle
162 oracle 1 59 -20 9480K 3096K sleep 39:58 0.02% tnslsnr
4204 root 1 58 0 5424K 2216K sleep 0:00 0.01% sshd
13 root 3 58 0 6528K 1248K sleep 16:55 0.00% vxconfigd
4598 root 1 35 0 968K 888K sleep 0:00 0.00% col
1 root 1 58 0 824K 160K sleep 20:03 0.00% init
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:27:30 EDT