oracle 查询表空间SQL

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  ;