RE: Oracle and cpu/core
Date: Thu, 5 Nov 2015 02:55:31 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA637132677_at_HKWPIPXMB03C.zone1.scb.net>
That’s a very large number of instances for a single server !
Have you considered 12c MultiTenant ?
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 05 2015 - 03:55:31 CET