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

Oracle Server Reference, Rel 7.3, January 1996 (Document A32589_1), page 1-13:

CPU_COUNT
Default value: automatically set by Oracle Range of values : 0 - unlimited
OK to change: No

This parameter lists the number of CPUs available to Oracle. Oracle uses it to set the default value of the LOG_SIMULTANEOUS_COPIES parameter. On single-CPU computers, the value of this parameter is 0.

Warning: On most platforms Oracle automatically sets the value of CPU_COUNT to the number of CPUs available to your Oracle instance. Do not change the value of CPU_COUNT.

If there is heavy contention for latches, change the value of LOG_SIMULTANEOUS_COPIES to twice the number of CPUs you have. Do not change the value of CPU_COUNT.

So, you should do

SELECT value FROM v$parameter WHERE name='cpu_count';

Hope this helps

Seva    

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 Tue Nov 04 1997 - 00:00:00 CST