DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001


    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
    Oracle DBA
    National Bank Of Kuwait

  2. #2
    Join Date
    Aug 2000
    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.


  3. #3
    Join Date
    Apr 2001
    Louisville KY
    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'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.