Calculate schema size in MB

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Calculate schema size in MB

Post by admin »

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;
Malik Sikandar Hayat
admin@erpstuff.com
SadeqEzzan123
Posts: 1
Joined: Wed May 03, 2023 4:07 am

Re: Calculate schema size in MB

Post by SadeqEzzan123 »

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

Who is online

Users browsing this forum: No registered users and 0 guests