查看数据库中指定用户下每个表占的实际空间大小

SELECT OWNER,SEGMENT_NAME,SUM(BYTES/1024/1024/1024)||'G' S FROM DBA_SEGMENTS WHERE OWNER = 'USERNAME' GROUP BY OWNER,SEGMENT_NAME ORDER BY S DESC;