4 Licensing Restrictions
This section covers the following topics:
4.1 Oracle Database XE CPU Limitations
Oracle Database XE limits itself automatically to two cores for processing. For example, on a computer with 2 dual-core CPUs (four cores), if a large number of database clients try to simultaneously execute CPU-intensive queries, then Oracle Database XE will process the queries at the rate of just two cores even if more CPU capacity is available.
To take advantage of the full processing power of your computer, you can use a different Oracle Database Edition such as the Oracle Database 18c Personal Edition, Oracle Database 18c Standard Edition 2, or Oracle Database 18c Enterprise Edition.
4.2 Oracle Database XE Installation and Execution Restrictions
Oracle Database XE restricts itself to only one installation per logical environment. The logical environment can either be a virtual host such as a VM or container, or a physical host. If more than one Oracle Database XE installation is attempted to be started in such a logical environment, an "ORA-00442: Oracle Database Express Edition (XE) single instance violation error" is raised and the database will not start. This does not affect any existing installation or new installations of Oracle Database 18c Personal Edition, Oracle Database 18c Standard Edition 2, or Oracle Database 18c Enterprise Edition. To run more than one Oracle Database instance or install more than one copy of the database software, upgrade to Oracle Database 18c Personal Edition, Oracle Database 18c Standard Edition 2, or Oracle Database 18c Enterprise Edition.
Oracle GoldenGate can not be used with Oracle Database Express Edition.
4.3 Oracle Database XE User Data Limitations
The maximum amount of user data in an Oracle Database XE database cannot exceed 12 gigabytes. If the user data grows beyond this limit, then an ORA-12592 error will appear. To use more than 12 gigabytes of user data, upgrade to Oracle Database 18c Personal Edition, Oracle Database 18c Standard Edition 2, or Oracle Database 18c Enterprise Edition.
4.4 Oracle Database XE RAM Limitation
The maximum amount of RAM that an Oracle Database XE database uses cannot exceed 2 gigabytes, even if more is available.
To use more than 2 gigabytes of RAM, upgrade to Oracle Database 18c Personal Edition, Oracle Database 18c Standard Edition 2, or Oracle Database 18c Enterprise Edition.
For more information about managing memory, refer to Oracle Database 2 Day DBA.