Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Neil.

Asked: February 10, 2020 - 1:28 pm UTC

Last updated: September 13, 2021 - 1:58 am UTC

Version: 11.2.0.4 Standard Edition x64

Viewed 1000+ times

You Asked

Hello!

Thanks for answering my questions regarding the testing of Oracle SE2's CPU thread limit on Oracle 11g Standard Edition - I really appreciate the informative response.

I have a related question...

If we have a server with, say, 18 CPUs hosting 4 SE2 single-instance databases, would each of the single-instances 'see' 16 CPUs (i.e., SE2's CPU thread limit) or would SE2's 16 CPU thread limit be shared between the instances, so they each see only 4 CPUs?

Similarly, if the same server hosted a single-instance database and one node of a 2-node RAC, which of the following would apply:

1. Single-instance would be limited to 16 CPU threads while the RAC node would be limited to 8
2. Single-instance would be limited to 8 CPU threads while the RAC node would also be limited to 8

I'm aware of the recent announcement re 19c SE2 no longer supporting RAC! These are just theoretical questions at the moment.

Many thanks,

Neil Garside

and we said...

This is from the Mar 19 license guide ( https://www.oracle.com/assets/lic-def-rules-v030819-5390819.pdf )

You are responsible for ensuring that the following restrictions are not violated:

Oracle Database Standard Edition 2 may only be licensed on servers that have a maximum capacity of 2
sockets. When used with Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be
licensed on a maximum of 2 one-socket servers. In addition, notwithstanding any provision in Your Oracle
license agreement to the contrary, each Oracle Database Standard Edition 2 database may use a maximum of
16 CPU threads at any time. When used with Oracle Real Application Clusters, each Oracle Database Standard
Edition 2 database may use a maximum of 8 CPU threads per instance at any time. If You purchase Named
User Plus (NUP) licenses, You must maintain a minimum of 10 NUP per server


Hence, it is No. 1 in your listed options ("Single-instance would be limited to 16 CPU threads while the RAC node would be limited to 8").

But please

a) take note of the responsibilities regarding *socket* count
b) always clarify with your local Oracle account representative. Anything regarding licensing on AskTOM is our opinion/interpretation only and should not be taken as official position by Oracle (because we in the team don't work for the licensing division)

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

19c SE2 thread count

Alan, September 09, 2021 - 2:38 pm UTC

Hi,
am trying to find a definitive answer on the thread count in SE2.

I have a server with 128 threads as show by the parameter cpu_count

to be compliant with the SE2 license do I set this parameter to 16

I cant seem to find anywhere on metalink a definitive guide on this

regards

Alan
Connor McDonald
September 13, 2021 - 1:58 am UTC

As long as you have no more than 2 sockets (physical CPUs) you're good.

SE will not use more than 16 concurrent CPU threads anyway - its baked into the kernel.

Good FAQ here

https://www.oracle.com/database/technologies/standard-edition-2-faq.html

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database