使用命令查看数据文件实际使用的大小和占有率 检查剩余空间 select sum(bytes)/(1024*1024) as free_space,tablespace_name from dba_free_space group by tablespace_name; 检查总共容量 Select bytes/(1024*1024) as total_space,name from v$datafile; 显示百分比 select A.tablespace_name,(1-(A.total)/B.total)*100 used_percent from (select tablespace_name,sum(bytes) total from dba_free_space group by tablespace_name) A, (select tablespace_name,sum(bytes) total from dba_data_files group by tablespace_name) B where A.tablespace_name=B.tablespace_name;