Re: Oracle 19c se2 licensing question

From: Clemens Bleile <"Clemens>
Date: Mon, 18 Nov 2019 21:48:57 +0000
Message-ID: <08D99D0C-0DC4-46FC-AC5F-B2F833474EA0_at_dbi-services.com>

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<mailto:clemens.bleile_at_dbi-services.com> www.dbi-services.com<http://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<mailto: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<mailto: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:48:57 CET