Re: Using NT Dual Processor for Oracle 7.3+ Enterprise for NT

You can use the NT Performance Monitor to verify that both CPUs are being used.

If you are using Oracle's Workgroup Server (and not the Enterprise Server), the only time you will use more than one CPU is if you have multiple sessions running (and therefore multiple DML statements). Each DML statement runs as a single thread underWGS.

In order to use both CPUs to process a single DML statement, though, you need to be using the Parallel Query Option, which is only available with the Enterprise Server. PQO will split DML statements into multiple threads (provided you have the DEGREE set to greater than 0/1 in either the table definition or by using a +HINT in the SQL statement).

Corry Retzke
corry_retzke at redstone dot net

thomasl_at_expansion.com wrote:

> Hello,
>
> I have a dual pentium processor with 130Megs of ram. I would like oracle to
> use both processors to maximize performance.
>
> Is there a way to tell if Oracle (server process) is using both processors?
>
> Is there a parameter that I must issue in the init<SID>.ora to enable multi
> processors?
>
> Based off my experience with databases, to use multiprocessors, one mut
> enable it. It is not an automatic thing. Please assist me on this.
>
> Please email thomasl_at_expansion.com
>
> Thanks
>
> Thomas Ladew
> Expansion System Corporation
> www.expansion.com
Received on Fri Nov 07 1997 - 00:00:00 CST