Hi all ,
1) In what ways a dual processor or any multiprocessor hardware setup helps to improve the overall performance of an NT based Oracle system.
2 ) Is there any oracle parmeters you have to set, to ulitize the capabilities of other processors available in a better manner
National Bank Of Kuwait
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.
Also consider setting the multiple dbwr parameters and parallelization parameters to 'assist' in utilizing the multiple cpus. It would be possible to virtually prevent the multiple cpu use by minimizing parallelization and/or not using multple dbwr's.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
Click Here to Expand Forum to Full Width