According to official Oracle documentation available at https://www.oracle.com/database/technologies/appdev/xe/faq.html it has limitations:

What are the resource limits for Oracle Database XE Oracle Database XE supports up to:

3 Pluggable Databases

2 CPUs for foreground processes

2GB of RAM (SGA and PGA combined)

12GB of user data on disk (irrespective of compression factor)

When running SQL

  TABLESPACE_NAME "Tablspace",  
   FILE_NAME "Filename",  
   BYTES/1024/1024 "Size MB"

I have the result:

Tablspace                      Filename                                                   Size MB
------------------------------ ------------------------------------------------------- ----------
USERS                          C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\USERS01.DBF         11,25
UNDOTBS1                       C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\UNDOTBS01.DBF        4230
SYSTEM                         C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\SYSTEM01.DBF         8630
SYSAUX                         C:\ORACLEXE18C\PRODUCT\18.0.0\ORADATA\XE\SYSAUX01.DBF          900


Which files does Oracle consider to validate the maximum size 12GB? Because if you make the sum of the 4 TableSpace I have already passed 12 GB.


1 Answer 1


The datafiles are used. If you are over size, you won’t notice this until you stop the database and try to start it again. Weird errors will appear like invalid size errors.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.