查询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 

转载于:https://blog.51cto.com/5371936/1618945