[Sunhelp] ?: Guidance on system sizing

[Wonkyu Chang - Sun Korea SE]

Hi,

IAHC having SS1000(2x85Mhz) with Oracle 7.2.
He said, "1 client connection usually invokes 100 queries."

The below was captured when about 250 clients(PC) was connected.

He asked me some guidance on how much to upgrade it.
Also, he's like to connect 500 clients concurrently.

oracle7] sar 1 10
 
SunOS titdb 5.5.1 Generic_103640-24 sun4d    06/24/99
 
11:56:54    %usr    %sys    %wio   %idle
11:56:55      82      18       0       0
11:56:56      85      15       0       0
11:56:57      85      15       0       0
11:56:58      85      15       0       0
11:56:59      83      17       0       0
11:57:00      78      22       0       0
11:57:01      84      16       0       0
11:57:02      81      19       0       0
 
oracle7] vmstat 1 10
 procs     memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr s0 s1 s6 sd   in   sy   cs us sy id
 5 0 0  16680  6988   0   4  3  1  2 1764 2 0  0  0  0   61  562   92  5  2 93
 147 0 0 243000 3076  4  21 140 148 164 1588 168 3 3 0 0 427 9251 1052 81 19 0
 146 0 0 242984 3084  8  30  8 20 12 1432 0 1  5  0  0  298 11251 869 83 17  0
 138 1 0 242936 3012  0  12  8  4  4 1292 0 0  2  0  0  314 7284  577 90 10  0
 153 0 0 242920 2996  1   7  0  8  8 1044 0 0  1  0  0  243 6107  624 86 14  0
 154 0 0 242912 2988  3   5  0  8  8 924 0  0  1  0  0  292 7478  788 85 15  0
 150 0 0 242424 2976  0  21  0  0  0 804 0  0  0  0  0  419 7895  643 81 19  0
 160 0 0 242268 3108  0  91 28 124 184 2680 286 5 0 0 0 263 5580  486 81 19  0
 143 0 0 242572 3188  2  63 28 20 20 2412 0 9 12  0  1  441 7156 1230 80 20  0
 153 0 0 243096 3324  0  57 28  0  0 2172 0 10 8  0  0  356 6920  790 85 15  0

oracle7] ps -ef |grep oracle |wc
     245    
 
========
MEMORY
========
System Configuration:  Sun Microsystems  sun4d
Memory size: 192 Megabytes

 
========
CPU
=======
  Status of processor 0 as of: 06/24/99 12:01:15
  Processor has been on-line since 06/22/99 10:19:49.
  The sparc processor operates at 85 MHz,
   and has a sparc floating point processor.
 Status of processor 1 as of: 06/24/99 12:01:15
  Processor has been on-line since 06/22/99 10:20:10.
  The sparc processor operates at 85 MHz,
   and has a sparc floating point processor.    
   
Thanks for any guidance.
WK Chang