RE: Oracle and cpu/core

  • From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • To: "woody.mckay@xxxxxxxxx" <woody.mckay@xxxxxxxxx>
  • Date: Thu, 5 Nov 2015 02:55:31 +0000

That’s a very large number of instances for a single server !

Have you considered 12c MultiTenant ?



Hemant K Chitale



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Woody McKay
Sent: Thursday, November 05, 2015 2:40 AM
To: ORACLE-L
Subject: Oracle and cpu/core

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

This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html

Other related posts: