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.