For more information on licensing details, see Oracle Database Database Licensing Information User Manual
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 Oracle Database 21c Standard Edition 2 or Oracle Database 21c 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 21c Standard Edition 2 or Oracle Database 21c Enterprise Edition. To run more than one Oracle Database instance or install more than one copy of the database software, upgrade to Oracle Database 21c Standard Edition 2 or Oracle Database 21c Enterprise Edition.
4.3 Oracle Database XE User Data Limitations
The maximum amount of user data in an Oracle Database XE database cannot exceed 12
GB. If the user data grows beyond this limit, then an
ORA-12592 error will appear. To use
more than 12 GB of user data, upgrade to Oracle Database 21c
Standard Edition 2 or Oracle Database 21c Enterprise
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 21c Standard Edition 2 or Oracle Database 21c Enterprise Edition.
For more information about managing memory, refer to Oracle Database 2 Day DBA.