Re: Oracle 19c se2 licensing question

Hi Vinay,

>> If I leave 40 cpu's on Linux server and change CPU_COUNT parameter to 16
For licensing concerns, you don't have to do anything as Oracle is actually doing that for you, using resource manager to limit the number of user sessions (more info about this:
https://blog.dbi-services.com/oracle-standard-edition-two/)

>> 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 For performance reasons, maybe (when you are ok with it) check that the instance runs on one numa node only. More info here: https://bdrouvot.wordpress.com/2015/01/07/measure-the-impact-of-remote-versus-local-numa-node-access-thanks-to-processor_group_name/ )

Regards,
Franck.

On Mon, Nov 18, 2019 at 10:58 PM Vinay Kumar Narisetty < narisetty.vinay_at_gmail.com> wrote:

> 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 3:49 PM Clemens Bleile (CBL) <
> clemens.bleile_at_dbi-services.com> wrote:
>
>> In SE2 you do license the number of sockets and not the number of cores.
>> If you have 1 socket with 20 cores and hyper threading enabled then you do
>> license 1 socket for the SE2. You cannot run more than 16 threads *per
>> database*. I.e. having 3 databases on the machine you may run with 48
>> active threads and can already overload your 20 core server.
>>
>>
>>
>> Regards
>>
>> Clemens
>>
>>
>>
>> *Clemens Bleile* | Principal Consultant & Oracle Technology Leader |
>> Oracle Certified Professional DB 11g, 12c | Oracle Certified Expert DB 12c
>> Performance Management and Tuning
>> Phone: +41 32 422 96 00 | Mobile: +41 78 677 51 09 | Fax: +41 32 422 96
>> 15
>>
>> dbi services, Rue de la Jeunesse 2, CH-2800 Delémont
>> clemens.bleile_at_dbi-services.com
>>
>> www.dbi-services.com
>>
>>
>>
>> *From: *<oracle-l-bounce_at_freelists.org> on behalf of Vinay Kumar
>> Narisetty <narisetty.vinay_at_gmail.com>
>> *Reply to: *"narisetty.vinay_at_gmail.com" <narisetty.vinay_at_gmail.com>
>> *Date: *Monday, 18 November 2019 at 21:44
>> *To: *Ghassan Salem <salem.ghassan_at_gmail.com>
>> *Cc: *oracle-l <oracle-l_at_freelists.org>
>> *Subject: *Re: Oracle 19c se2 licensing question
>>
>>
>>
>> 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