DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: cpu_count

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unhappy cpu_count

    Can somebody tell me what is cpu_count and how can I find out?

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: cpu_count

    Hi,
    CPU_COUNT specifies the number of CPUs available to Oracle. On single-CPU computers, the value of CPU_COUNT is 1.
    This parameter typically is used in the calculateion of the default value of other parameters in various releases, and to decide if 'latch spinning' is appropriate. Eg: It is used to derive a value for .
    On most platforms Oracle automatically sets the value of CPU_COUNT to the number of CPUs available to your Oracle instance. Do not change the value of CPU_COUNT unless specifically advised to do so.
    If there is heavy contention for redo latches, change the value of
    LOG_SIMULTANEOUS_COPIES to twice the number of CPUs you have. Do not change the value of CPU_COUNT.

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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