查询oracle数据中所有表的大小

select t.bytes,TO_CHAR((t.bytes)/(1024*1024),'999G999D999'),

t.* from sys.dba_segments t where t.owner='xxxxx'

order by t.bytes desc