Oracle and cpu/core

  • From: Woody McKay <woody.mckay@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Nov 2015 13:40:08 -0500

Hi,

Our hosting unit is designing a large server and want to put about 96 SID's
on it. They've worked through I/O and RAM considerations. This is on Win
64 2012 R2.

However, they are not sure about cpu/core count and usage. They currently
have 64 cores and need to know how many of the cores will each SID
(oracle.exe) can/will use. If a SID can't use all cores, then what's the
best way to spread the SIDs across all the cores. I talked about cpu
groups, but they said that Oracle always picks cpu group 0 on startup and
they have to manually reassign the groups to each oracle.exe process.

I've only had about 40 SIDs on a box with 24 cores, so I don't really have
the experience to provide the best answers.

Any thoughts? Thanks

--
Sincerely,

WoodyMcKay

Other related posts: