Please find all our articles about Oracle Database Standard Edition 12.1.0.2 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 12.1.0.1 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 12.1.0.2 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:
More information?
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
–Mike
Here is a CPU-thread calculation from an Oracle Partner Pricing document:
===Quote===
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.
===/Quote===
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
——————————-
32
Greets Ingo
Hello Mike!
In an environment with only one server SE2, how many CBD Within one PDB can I have?
Thanks!
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).
Cheers
Mike