Calculate schema size in MB
Posted: Wed Nov 02, 2022 5:25 am
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, sum(bytes)/1024/1024 Size_MB from dba_segments
group by owner;