select segment_name,tablespace_name,bytes,blocks from user_segments order by TABLESPACE_NAME,bytes; 方便管理 或者这样也可以 select b. file_id 文件ID号, b.tablespace_name 表空间名, b.bytes 字节数, (b.bytes - sum (nvl(a.bytes, 0 ))) 已使用, sum (nvl(a.bytes, 0 )) 剩余空间, sum (nvl(a.bytes, 0 )) / (b.bytes) * 100 剩余百分比 from dba_free_space a,dba_data_files b where a. file_id = b. file_id group by b.tablespace_name,b. file_id ,b.bytes order by b. file_id