I think "select sum(bytes) from dba_segments where owner='SCHEMA'" should work.