Re: Oracle and cpu/core

From: Phil Jones <phil_at_phillip.im>
Date: Wed, 4 Nov 2015 23:51:46 +0000
Message-Id: <128A034D-22B6-4875-B0BD-CB49D9F979AE_at_phillip.im>

I hope they're not public (scarce IPv4) addresses...

Phil

> On 4 Nov 2015, at 23:04, Woody McKay <woody.mckay_at_gmail.com> wrote:
> 
> Hi Angelo,
> 
> Thanks for the thoughts.  This project will use 12.1.0.2 + Oct CPU patches for DB and OJVM.
> 
> Yeah, nightly backups will be an issue. I've recommended thinking about a hardware solution.  One thought was something like a 3 disk mirror and just snapping off a disk each night.  This issue is still being debated. 
> 
> Will for sure do the pros and cons and present. 
> 
> 
> 

>> On Wed, Nov 4, 2015 at 3:33 PM, angelo <angelolistas_at_gmail.com> wrote:
>> Hello Woody,
>>
>> Oel and multitenant sounds good, with 12c
>>
>> By the way, on this project will they use 12c or 11g ?
>>
>> About Windows, what about the cpu, I think it will stuck...
>>
>> let´s enumerate the cons, not the pros..
>>
>> => would be hard to manage..
>>
>> => Could they imagine how to do an backup of all these databases ? Or running an export ? What do they do when the database grows? multiply by 96
>>
>> => 96 IPs makes things very complicated.. you will need a class C range to attend them.
>>
>>
>> Well, my sugestion, do a annotation of all pros and cons..and show them
>>
>> Good luck with this project
>>
>> regards
>>
>> angelo
>>
>>
>>

>>> On 4 November 2015 at 17:29, Woody McKay <woody.mckay_at_gmail.com> wrote:
>>> Hi Angelo,  
>>> 
>>> Yes it is a stand alone. Actually it will be leased through RackSpace.  They are helping with the design and will be with the hosting team for the day-to-day support. 
>>> 
>>> They are also talking about switching to OEL and multi-tenant in a year or two.  But, stuck with Windoz for now...
>>> 
>>> As an update, some on the list will remember my question a couple of weeks ago on listeners.  I was able to convince them to go with one listener per SID. But, instead of 96 ports, they want to use 96 IP's.  I checked with Oracle support and they said as long as the IP:Port combo was unique that they would support it.
>>> 
>>> 
>>> 
>>> 
>>> 
>>>> On Wed, Nov 4, 2015 at 1:45 PM, angelo <angelolistas_at_gmail.com> wrote:
>>>> My opinion.. They are crazy...
>>>> 
>>>> So many instances on the same server, Windows server ..  (is it stand alone ?)
>>>> 
>>>> 
>>>> 
>>>>> On 4 November 2015 at 16:40, Woody McKay <woody.mckay_at_gmail.com> wrote:
>>>>> 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
>>> 
>>> 
>>> 
>>> -- 
>>> Sincerely,
>>> 
>>> WoodyMcKay
> 
> 
> 
> -- 
> Sincerely,
> 
> WoodyMcKay

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 05 2015 - 00:51:46 CET