Oracle XE 18c database size limitation

Asked

Viewed 12 times

0

According to official documentation from Oracle available in https://www.oracle.com/br/database/technologies/appdev/xe/faq.html has the limitations:

What are the resource limits of Oracle Database 18c XE Oracle Database 18c XE supports:

3 Connected Databases 2 Cpus for Foreground Processes 2 GB RAM (combined SGA and PGA) 12 GB of user data on disk (irrespective of the compaction factor)

When running the SQL

select 
  TABLESPACE_NAME "Tablspace",  
   FILE_NAME "Filename",  
   BYTES/1024/1024 "Size MB"
from 
  SYS.DBA_DATA_FILES;

got 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

Doubt

Which files the Oracleconsider to do the validation of 12GB of maximum size? For if you do the sum of the four TableSpace I’ve already passed 12 GB.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.