Re: dual processor

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 Wed Sep 30 1998 - 03:49:43 CDT