Disabling CPU's for Oracle on win2K
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Disabling CPU's for Oracle on win2K

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    Disabling CPU's for Oracle on win2K

    Dear members,

    We have 4-node Oracle RAC with 8-cpu each on win2k. We would like to disable 4 CPUs per node.

    Questions:

    1) Can this be done through Oracle? and How>

    2) Can the CPUs be disabled through the win2K O/S, and how?

    3) Is unplugging the CPU's from the mother board a good option?

    Please compare and contrast these options for me...anxiously awaiting your help.

    Thanks!

  2. #2
    Join Date
    Feb 2003
    Posts
    67
    Yank them out of their socket or call the box's tech support to do it for you.

    Why are you doing this? Too much processing power?

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    licensing issue, i'd guess?

    pull 'em out of the box.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    HELP!!!

    Any more help on this thread would be highly appreciated!

    Thanks!

  5. #5
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    More help!!

    Some windows 2K experts say pulling them out of the box will need some additional hardware to terminate the empty cpu slots that are pulled out. Is this right?

    Also - I found an oracle windows registry parameter ORACLE_AFFINITY which allows one to restrict Oracle processes only to certain CPU's...

    Please advice the best method...anyone out there with experience on this type of project?

    Thanks again!

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    If this is a licensing issue then you had bettercheck with Oracle Sales to makesure that these options are "approved" by them. If they say that the ORACLE_AFFINITY method is not acceptable, then that'll kind-of help you.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: More help!!

    Originally posted by roukie_dba
    Some windows 2K experts say pulling them out of the box will need some additional hardware to terminate the empty cpu slots that are pulled out. Is this right?
    That depends on the hardware. The few Intel-based servers I have set up arrived with one CPU and the other slots filled with terminators - I tend to keep such things; do you?

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