Re: Oracle 19c se2 licensing question

From: Peter Gram <peter.m.gram_at_gmail.com>
Date: Mon, 18 Nov 2019 22:17:28 +0100
Message-ID: <CAJ=80GVy+hbqh9HT+w9Mvm+pZ=yxV2vvMxEHUhyGc1+_O37axg_at_mail.gmail.com>



Hi

The 16 threads per database is a technical restraint Oracle put in SE2 code to limit the benefit of putting a single Oracle SE2 on big servers since modern CPU can have 20+ cores.
From a licensing perspective a SE2 license is per socket (Physical CPU on the om the motherboard).
Sow a single SE2 database on a database server with more than 18 cores (2 cores to drive O/S) is wast of Oracle licenses but having 2 -10 databases on 1/2 SE2 licenses
a good investment if you can live with out the EE features :-)

Best regards

Peter Gram
Sæbyholmsvej 18 DK-2500 Valby

Cell: (+45) 5374 7107
Home: (+45) 3874 5696
Email: peter.m.gram_at_gmail.com
linkedin: dk.linkedin.com/in/petergram/
OakTable : oaktable.net/members <http://oaktable.net/members>

On Mon, 18 Nov 2019 at 21:44, Vinay Kumar Narisetty < narisetty.vinay_at_gmail.com> wrote:

> Actually 20 cpu's. Over Linux admin turn on hyper threading. Is it ok
> from licensing standard point to have 40 cpu's count on server ?
>
> lscpu
> Architecture: x86_64
> CPU op-mode(s): 32-bit, 64-bit
> Byte Order: Little Endian
> CPU(s): 40
> On-line CPU(s) list: 0-39
> Thread(s) per core: 2
> Core(s) per socket: 10
> Socket(s): 2
> NUMA node(s): 2
> Vendor ID: GenuineIntel
> CPU family: 6
> Model: 85
> Model name: Intel(R) Xeon(R) Gold 5115 CPU _at_ 2.40GHz
> Stepping: 4
> CPU MHz: 2400.000
> CPU max MHz: 3200.0000
> CPU min MHz: 1000.0000
> BogoMIPS: 4800.00
> Virtualization: VT-x
> L1d cache: 32K
> L1i cache: 32K
> L2 cache: 1024K
> L3 cache: 14080K
> NUMA node0 CPU(s):
> 0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38
> NUMA node1 CPU(s):
> 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39
>
> Regards,
> Vinay Narisetty
>
> On Mon, Nov 18, 2019 at 1:38 PM Ghassan Salem <salem.ghassan_at_gmail.com>
> wrote:
>
>> 40 cpus?
>> Any way, you can have as many dbs as you want on this server. Eacj won't
>> use more than 16 threads for user processes at any given time.
>>
>> Rgds
>>
>> On Mon, Nov 18, 2019, 20:18 Vinay Kumar Narisetty <
>> narisetty.vinay_at_gmail.com> wrote:
>>
>>> Hi All,
>>>
>>> Over database version is Oracle 19c SE2.
>>> We have 1 socket with 40 cpu's on the server.I see Oracle SE2 limitation
>>> with 16 threads.It seems like I need to use only 16 cpu's on the server. Is
>>> that correct ?
>>>
>>> If I leave 40 cpu's on Linux server and change CPU_COUNT parameter to 16
>>> on each database instance. Do I covered with SE2 licensing on 19c
>>> database?Do I have any licensing issue with oracle LMS auditing ?
>>>
>>> Please advice!
>>>
>>> Regards,
>>> Vinay Narisetty
>>>
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 18 2019 - 22:17:28 CET

Original text of this message