To query Oracle to find the schema size run the following sql:

select owner,sum(bytes) from dba_segments
group by owner;

If you do not have dba privs then use the table user_segments instead of dba_segments.