Clarification on dual processor
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Clarification on dual processor

  1. #1
    Join Date
    Oct 2001
    Location
    Kuwait
    Posts
    23

    Question

    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
    Posts
    236
    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..

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