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;
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;