Re: Multiprocessor NT Configuration

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Fri, 9 Apr 1999 13:25:05 +0200
Message-ID: <7ekod3$qc4$1@korweta.task.gda.pl>

Don Hall wrote in message <370D28F3.C0BE5291_at_twoil.com>...
>Hello All,
> I am planning to install Ver. 8.05 on a server with two PII-350
>processors. Can Oracle take advantage of the multiprocessor
>configuration? If so, does it require any special configuration
>parameters in the INI file or elsewhere?.

On NT Oracle correctly recognizes no of CPU's and obviously, overall performance takes advantage of additional processor/s/. But remember, that NT scalability is not linear, and Oracle scalability is not able to be better than the platform's one.

About Oracle: usually it is necessary to make sure that Oracle wouldn't waste some CPU.
Generally, we need adjusting parameters which defaults are derived from number of CPUs:
log_simultaneous_copies = 2*<no_of_cpu> (default: no_of_cpu) db_block_lru_latches = <no_of_cpu> (default: no_of_cpu/2)

They reduces the risk that threads executed concurrently on available CPUs spin wasting CPU time or need to sleep trying to enter critical section.

--
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Fri Apr 09 1999 - 06:25:05 CDT