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;
Calculate schema size in MB
Calculate schema size in MB
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
-
- Posts: 1
- Joined: Wed May 03, 2023 4:07 am
Re: Calculate schema size in MB
Select owner, sys.dbms_xplan.format_size(bytes) as SIZE_MB from sys.dba_segments;
Who is online
Users browsing this forum: No registered users and 33 guests