Using the query below, you can check the size of each Oracle schema.
Code: Select all
set pages 999
col "size MB" format 999,999,999
col "Objects" format 999,999,999
select obj.owner "Owner"
, obj_cnt "Objects"
, decode(seg_size, NULL, 0, seg_size) "size MB"
from (select owner, count(*) obj_cnt from dba_objects group by owner) obj
, (select owner, ceil(sum(bytes)/1024/1024) seg_size
from dba_segments group by owner) seg
where obj.owner = seg.owner(+)
order by 3 desc ,2 desc, 1
/Code: Select all
Owner Objects size MB
--------------- ------------ ------------
SYS 22,909 497
SH 306 56
SYSMAN 1,341 49
XDB 680 49
MDSYS 937 33
SYSTEM 456 23
OLAPSYS 720 16
OE 127 9
WMSYS 315 8
CTXSYS 313 5
EXFSYS 282 4
PM 26 3
IX 53 2
DBSNMP 50 2
HR 34 2
ORDSYS 1,721 1
DMSYS 189 1
OUTLN 9 1
SCOTT 6 1
TSMSYS 3 1
PUBLIC 20,090 0
ORDPLUGINS 10 0
BI 8 0
ORACLE_OCM 8 0
SI_INFORMTN_SCH 8 0
EMA