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 in Oracle database 18c XE 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 in Oracle database 18c XE.
2. Threads:- We can only have 2 user threads in Oracle database 18c XE.
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 in Oracle database 18c XE.
4. Memory:- We can only have RAM up to 2GB(max) in Oracle database 18c XE.
5. Storage:- We can only have 12GB of user data stored (max) in Oracle database 18c XE.
Some important Key features in 18c XE :-
1. Pluggable databases :- Oracle Multitenant Container Database only can have Up to 3 Pluggable Databases in Oracle database 18c XE.
2. Compression :- Basic Table Compression and Index Compression in Oracle database 18c XE.
3. Encryption :- Transparent Data Encryption(TDE) which enables you to encrypt sensitive data that you store in tables and tablespaces in Oracle database 18c XE.
4. partitioning :- Enhance performance, availability, and manageability in Oracle database 18c XE.
We can now run multiple Oracle database 18c XE installations inside multiple VMs/Containers with one each. That means that we can run 4 instances on 4 VMs, one instance per VM.
Keep sharing :)
Keep sharing :)