Re: oracle and multiple processors

In article <7ai01d$1ml$1_at_nnrp1.dejanews.com>,   christine_at_techresource.org wrote:
> If a database is running on an smp o/s, like solaris,
> then does it have anything todo with it's usage of the multiple
> processors. Shouldn't the o/s take care of all that for the
> database?
>
> Do user applications like a database have to be
> tuned for smp operating systems?
>
> If so is oracle running on solaris the best at this?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Solaris does take care of SMP in general, but to optimize the rdbms performance, there are several parameters that you may need to adjust:

1. log_simultaneous_copies should be set to 2xCPUs
2. log_small_entry_max_size = 64
3. If you have >= 4 CPUs, set parameters parallel_min_servers and parallel_max_servers to 4xCPUs and 16xCPUs respectively. If your database isn't on raw devices, you should set parameter db_writers (or dbwr_io_slaves) to the min(#disks_with_database_files,#CPUs). If it is, you should check that use_async_io is set to true. In case of version 7, also don't forget to set checkpoint_process=true.

Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 18 1999 - 17:02:40 CST