Re: Oracle 9i on Dual-Board Intel Linux? Experiences?

From: Bon-Minh Lam <no_spam_at_bmlam.de>
Date: Tue, 16 Jul 2002 00:41:57 +0200
Message-ID: <3D334FB5.6EDC0391@bmlam.de>

Christof, to answer your question: does Oracle makes use of both CPU's? The answer is positive. "top" normally show both CPU's less than 5 percent busy. But when a parallel DML is running, utilization on both processors surges as shown by the this "top" output screen:

top outout ****************************** 125 processes: 122 sleeping, 3 running, 0 zombie, 0 stopped CPU0 states: 31.1% user, 5.1% system, 0.0% nice, 63.2% idle CPU1 states: 21.5% user, 10.3% system, 0.0% nice, 67.1% idle Mem: 512924K av, 509860K used, 3064K free, 97824K shrd, 3288K buff Swap: 2048248K av, 262856K used, 1785392K free 173192K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND

 1410 oracle    17   0 62972  29M 29524 R    45.2  5.9   0:17 oracle
 4563 oracle    14   0 22984  21M 22040 S    12.0  4.3   0:16 oracle
 4565 oracle    10   0  4976 4656  4280 R     5.4  0.9   0:11 oracle
 1412 oracle    16   0  1104 1104   856 R     2.1  0.2   0:00 top
12723 oracle    10   0  9040 8904  7508 S     0.9  1.7   0:04 kdeinit
 1164 root      11   0 70040  21M  3916 S     0.7  4.1  17:18 X
  232 root      12   0     0    0     0 DW    0.5  0.0   0:06 kjournald
 1371 oracle     9   0 41652 9120  8440 S     0.5  1.7   0:00 oracle
    5 root      10   0     0    0     0 SW    0.3  0.0   0:15 kswapd
 1709 oracle    10   0  5412 4960  4016 S     0.1  0.9   0:21 kdeinit
 1715 oracle    10   0  8488 7828  4732 S     0.1  1.5   0:38 kdeinit
 7272 oracle     9   0  9116 9020  7332 S     0.1  1.7   0:09 kdeinit
    1 root       8   0   120   72    72 S     0.0  0.0   0:04 init
    2 root       9   0     0    0     0 SW    0.0  0.0   0:02 keventd
    3 root      19  19     0    0     0 SWN   0.0  0.0   0:01
ksoftirqd_CPU0
    4 root      19  19     0    0     0 SWN   0.0  0.0   0:00

ksoftirqd_CPU1

HTH Christof Kaiser schrieb:

> Hi there,
>
> I am wondering if someone can give me hints about running 9i on Linux
> (any version) on a Dual-Board Intel-Based PC.
>
> -does it work?
> -which versions (Linux, Oracle) and PC components (Processors, Boards)
> are you using?
> -how fast ist it?
> -how stable ist it?
> -are there special traps i should be aware of?
>
> I dont expect definite answers but some hints or links would be great.
>
> I am quite happy with Oracle 9i on SuSE 7.1 but would like more speed.
> Our application is very scalable and can take advantage of multiple
> processores ie of a SUN.
> But, as we know, Intel PCs are faster and much cheaper.
>
> Reagrds
> Christof

--
To reply to me directly, please mail to: bmlam at online dot de

Received on Mon Jul 15 2002 - 17:41:57 CDT