Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XE DB max size

stephane trotinMar 7 2025

Hello

I would like to get a query to show if I 'm far away from the 12 Gb max size

I've got a multitenant db

is it ok :

<table><tbody><tr><td style="height:14.4pt;width:48pt;">select file_name,tablespace_name, bytes,con_id from cdb_data_files where online_status &lt;&gt; 'SYSTEM' and tablespace_name not like '%UNDO%'</td></tr></tbody></table>
Comments
Post Details
Added on Mar 7 2025
0 comments
220 views