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
select
TABLESPACE_NAME "Tablspace",
FILE_NAME "Filename",
BYTES/1024/1024 "Size MB"
from
SYS.DBA_DATA_FILES;
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
## Question
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.
Asked by Tiedt Tech
(101 rep)
Aug 30, 2021, 04:28 PM
Last activity: Aug 5, 2023, 06:04 AM
Last activity: Aug 5, 2023, 06:04 AM