ERPstuff - Oracle EBS Community

Normally companies are giving APEX as a service and they need to calculate the space used by each Schema/WS,

select owner, sum(bytes)/1024/1024 Size_MB from dba_segments
group by owner;

Select owner, sys.dbms_xplan.format_size(bytes) as SIZE_MB from sys.dba_segments;