Re: Oracle and cpu/core

  • From: Woody McKay <woody.mckay@xxxxxxxxx>
  • To: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
  • Date: Thu, 5 Nov 2015 10:19:06 -0500

Hi Hemant,

Yes, moving to OEL and multi-tenant is the target, but it is 1-2 years away.


On Wed, Nov 4, 2015 at 9:55 PM, Chitale, Hemant K <Hemant-K.Chitale@xxxxxx>
wrote:

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




--
Sincerely,

WoodyMcKay

Other related posts: