1. 检查当前用户使用的表空间
select default_tablespace from user_users;
2. 检查表空间名称、使用、空闲、占用率、空闲率
select
2 f.tablespace_name,
3 a.total,u.used,f.free,round((u.used/a.total)*100)"%used",
4 round((f.free/a.total)*100) "% Free"
5 from
6 (select tablespace_name, sum(bytes/(1024*1024)) total from dba_data_files group by tablespace_name) a,
7 (select tablespace_name, round(sum(bytes/(1024*1024))) used from dba_extents group by tablespace_name) u,
8 (select tablespace_name, round(sum(bytes/(1024*1024))) free from dba_free_space group by tablespace_name) f
9 where a.tablespace_name = f.tablespace_name
10 and a.tablespace_name = u.tablespace_name
11 ;