Hi,
I have an Oracle database (8.1.6 - I know it's unsupported, but it's
due to be phased out and so nobody wants to 'waste' time, money and
resource upgrading it) on a Compaq Tru 64 server. Overnight batch
processing is running like a dog and my belief is that the server could
do with a memory upgrade. However, the UNIX performance team are
stating that the memory usage is fine, as 'Nevertheless, both paging
(<2 pages/sec), scan rate (< 10 pages/sec) &
paging space (<10%) are all well below their recommended thresholds of
50
pg/sec, 250 pg/sec & 60% throughout the day.' Below is the output from
vmstat, swapon -s and top taken during the day, a period during which
there is very low activity. Could anyone tell me whether the details
provided support my belief that memory is a primary cause of poor
performance on this server?
Regards,
Rob
P.S. I also have vmstat statistics taken at 5 minute intervals during
one of the overnight processing runs available if anybody would like to
view these.
Virtual Memory Statistics: (pagesize = 8192)
procs memory pages intr
cpu
r w u act free wire fault cow zero react pin pout in sy cs us
sy id
3 267 37 393K 24K 96K 2640M 233M 912M 33M 368M 1M 242 5K 2K
18 5 78
5 262 37 393K 25K 96K 270 15 203 0 12 0 217 8K 1K
12 2 86
5 262 37 393K 24K 96K 961 1 316 0 207 0 153 5K 1K
7 2 91
3 265 36 393K 24K 96K 182 0 158 0 0 0 142 5K 1K
7 2 91
3 261 40 393K 24K 96K 811 1 316 0 71 0 199 3K 1K
6 3 91
4 260 36 392K 25K 96K 224 0 158 0 31 0 154 11K 2K
14 3 83
6 254 37 392K 25K 96K 780 1 308 0 52 0 173 6K 1K
9 15 76
3 256 36 392K 26K 96K 184 0 153 0 3 0 142 1K 1K
10 3 87
3 252 38 392K 26K 96K 705 1 298 0 28 0 142 5K 1K
8 2 90
4 252 37 392K 26K 96K 179 0 147 0 0 0 176 5K 1K
9 2 89
3 254 36 392K 26K 96K 672 1 294 0 18 0 143 7K 1K
18 4 78
3 255 36 392K 25K 96K 1028 49 615 0 102 0 218 6K 3K
6 3 91
pscu244a_# swapon -s
Swap partition /dev/re0b (default swap):
Allocated space: 500000 pages (3906MB)
In-use space: 28418 pages ( 5%)
Free space: 471582 pages ( 94%)
Total swap allocation:
Allocated space: 500000 pages (3906MB)
Reserved space: 144603 pages ( 28%)
In-use space: 28418 pages ( 5%)
Available space: 355397 pages ( 71%)
load averages: 0.51, 0.42, 0.42
10:41:48
143 processes: 1 running, 3 waiting, 49 sleeping, 90 idle
Cpu states: % user, % nice, % system, % idle
Memory: Real: 2909M/4116M act/tot Virtual: 222M/3906M use/tot Free:
195M
Received on Mon Mar 20 2006 - 06:58:33 CST
