Oracle database 18c XE
Oracle Database 18c XE is a free for use but with below limitations on H/W and memory:-
1. Instance:- We can only have one
instance per server with the instance name XE. Please be aware that we cannot
change the name of the instance. This is
default and it is not clear whether we are allowed to change it.
2. Threads:- We can only have 2 user threads.
3. CPU:- We can only have 2 CPUs(max) in 18c XE. If your
machine have more CPU’s it will not count more than two CPU’s.
4. Memory:- We can only have RAM up
to 2GB(max).
5. Storage:- We can only have 12GB of user data stored (max).
Some important Key features in 18c XE :-
1. Pluggable databases :- Oracle Multitenant Container Database only can
have Up to 3 Pluggable Databases.
2. Compression :- Basic Table Compression and
Index Compression.
3. Encryption :- Transparent Data Encryption(TDE)
which enables you to encrypt sensitive data that you store in tables and
tablespaces.
4. partitioning :- Enhance performance,
availability, and manageability.
We can now run
multiple XE installations inside multiple VMs/Containers with one each. That means that we can run 4
instances on 4 VMs, one instance per VM.
Oracle Mean company, not database :)