How to check size for each user



How to check size for each user.


select DISTINCT(OWNER),SUM(BYTES)/1024/1024/1024 as gigas
from  dba_segments
where owner not in ('SYS','SYSTEM')
group by OWNER;

Comments