oracle统计用户下表的大小

Select username,default_tablespace,created from dba_users order by created desc;
select segment_name, bytes/1024/1024/1024 from dba_segments where owner in ("WLS816","WYJK","XCYS","PERFSTAT","TROUBLE","DLWH","OSSLOG","WEBLOGIC","TELECOM","TELECOMNEW") and SEGMENT_TYPE="TABLE" order by 2 desc;