more processors to the database box

[ashley75]

Orgianlly, we only have one processor and we are planning to add one more processor on this box. I notice that I have to change some parameter in the init.ora file

1. CPU_count=2

could someone explain why I have to add this parameter on the init.ora file ???


Is there anything else I need to change on the init.ora at all ???? What about the latches, etc........


Please give me some advise if you are running multiple processors ???

Thanks

[pipo]

no, you don't have to change this value for Oracle will manage it by itself.
there aren't that many differences when running with several processors, and as fas as Oracle is concerned, you have NOTHING to change ...

in previous releases (prior to 8i) there was a parameter called log_simultaneous_copies, but it is now obsolete

[julian]

Do not touch CPU_COUNT. It is Oracle-managed parameter. Increase the number of DB writes, make them equal to the number of CPUs. Yes, the latches, etc.

[omegamark]

At times people buy Oracle licence based on the number of processor .In that case you have to shell out a lot of money for the additional processor ...

check before