schema size

All schema sizes
-----------------
select OWNER,sum(BYTES)/1024/1024/1024 GB from dba_segments
group by OWNER
order by GB
/

only one schema size
----------------------
SELECT SUM(BYTES)/1024/1024/1024 "GB" FROM DBA_SEGMENTS WHERE OWNER='schemaname'
/