Re: dual processor

Hi,

    I disagree with MotoX on this issue. OPQ is not required in order to benefit from the multiple processors in an NT server. With multiple processors and no OPQ it is certainly true that no one query will be able to take advantage of the multiple processors, but whenever more than one query is being operated on you will benefit from the presence of an additional processor.

    Just fire up the performance monitor on and look at the processor activity on your system and you will see that Oracle automatically takes advantage of the additional processors.

regards

Jerry

MotoX wrote in message
<907145285.2474.0.nnrp-03.c2de712e_at_news.demon.co.uk>...
>Well, before you start on *any* of this, decide exactly *what* you are
>hoping to gain. In detail.
>
>To exploit the dual-processor architecture will almost certainly require
the
>installation of OPQ, if you haven't installed it already. And you will
>almost certainly have to look at re-engineering your database and the sql
>you throw at it to *fully* exploit OPQ - and you will probably have to
>re-org your disk subsystem so that doesn't become the bottleneck.
>
>Moving a system *properly* over to a parallel environment is not a simple
>task. Read up on OPQ, especially as regards to what it *can do*, and what
it
>*can't do* - it's very easy to paralellise operations and make performance
>much *worse*. Don't be sucked into the belief that 'more is better'.
>
>So, read up, and maybe get some training. And monitor, test and tune (both
>the db and the OS and the hardware) as you progress. Things you sometimes
>*think* will improve will not. I've moved a few systems over from
>uni-processor to 2, 4 and 8 way servers, and getting decent gains is not
>easy in my experience. But do it properly, and the gains can be
substantial.
>
>Regards,
>
>MotoX.
>
>
>Datasyst wrote in message <6uq7mj$nj1$1_at_nslave1.tin.it>...
>>Please I need some help to configure Oracle Server 7.3.4 under Windows NT
>>with a machine equipped with two processors.
>>I have read some information on Oracle DBA Handbook but I'm not so sure
>>about it!!
>>Can someone tell me how I have to modify my INIT.ORA file ??
>>What parameters Have I to insert in :
>>- PARALELL_MAX_SERVERS
>>- PARALELL_DEFAULT_MAX_INSTANCES
>>- ecc.
>>
>>Thanks
>>Frank
>>
>>
>
>
Received on Fri Oct 02 1998 - 13:06:20 CDT