1.查询表空间剩余大小:
select a.tablespace_name, a.bytes/1024/1024 "total(MB)",b.bytes/1024/1024 "used(MB)", c.bytes/1024/1024 "free(MB)",(b.bytes*100)/a.bytes "%used" from sys.sm$ts_avail a,sys.sm$ts_used b,sys.sm$ts_free c where a.tablespace_name=b.tablespace_name and a.tablespace_name=c.tablespace_name;
2.查询表空间使用百分比:
select * from dba_tablespace_usage_metrics;
3.根据表空间名查询其中表占用的空间大小(dba_extents)
select segment_name, tablespace_name, sum(bytes / 1024 / 1024) || 'M'
from dba_extents
where tablespace_name = 'SMSC_CENTER'
group by segment_name, tablespace_name
order by 3 desc;
//查看系统表空间使用的裸设备
set linesize 2000;
select tablespace_name, file_id, file_name, round(bytes/(1024*1024),0)||'M' total_space from dba_data_files order by tablespace_name;