Please find all our articles about Oracle Database Standard Edition 126.96.36.199 SE2:
- Sept 17, 2015:
SE2 – Some questions, some answers
- Sept 8, 2015:
MOS Download for Oracle SE2
- Sept 7, 2015:
Support and Patches for Oracle 188.8.131.52 SE/SE1
- Sept 3, 2015:
Can you have Multitenant with Oracle SE2?
- Sept 1, 2015:
Oracle Standard Edition SE2 available for download
Can you have Oracle Multitenant in Oracle Standard Edition 184.108.40.206 SE2?
No, you can’t as Oracle Multitenant is a licensable option for Enterprise Edition (EE) databases only.
But wait a second …
You can do Oracle Single Tenant with SE2 of course meaning you can have one active pluggable database within one container database at a time. That is possible and does not require any additional licenses.
See the DBCA (Database Configuration Assistant) screen when you’ll try to create a container database:
You’ll find more information about the differences in handling and such between Oracle non-CDB, Oracle Single Tenant and Oracle Multitenant databases in this presentation:
- How Oracle Single Tenant will change a DBA’s life
Here is a CPU-thread calculation from an Oracle Partner Pricing document:
Note: The new 16 CPU thread cap is a technical limitation in the Database program, not merely a contractual license limitation. SE2 database cannot utilize more than 16 threads at any time. On a typical Intel processor, each core contains two (2) threads. For example, a 2-socket Intel-based server may contain two processors each having 10 cores, so the server has 20 threads in total (if hyper threading is enabled); SE2 will utilize a maximum of 16 threads at any time.
Does this mean with 2 "Single Tenant" DB-Instances (no RAC) (CDB1 (PDB1) + CDB2(PDB2)) on one 2-Socket Server totaly having 32 threads (2x 8-Core(HT)-CPUs), these 32 would be completely used?
CDB1(PDB1) = 16 DB-CPU threads
CDB2(PDB2) = 16 DB-CPU threads
In an environment with only one server SE2, how many CBD Within one PDB can I have?
As far as my license understanding goes you can create as many SE2 Container databases as you want on this server – but each of them can only have one PDB (the PDB$SEED does not count).