Since Oracle runs as threads within a master Oracle process (Multi threaded architecture), resource swapping between individual threads is automatic. And Windows NTS/2000 automatically utilizes multi CPU's where available.

The only init parameters I can think of for tuning multi CPU systems is DB_BLOCK_LRU_LATCHES (either (CPU_COUNT x 2 x 3) or (DB_BLOCK_BUFFERS/50), whichever is less) .


Oracle automatically sets CPU_COUNT parameter. Do not set this.

Also, If your system experiences 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.


Nizar..