Oracle 查询表空间使用率 SQL 语句

setline222colpagesize1000colTABLESPACE_NAMEfora40selecttbs_used_info.tablespace_name,
tbs_used_info.alloc_mb,
tbs_used_info.used_mb,
tbs_used_info.max_mb,
tbs_used_info.free_of_max_mb,
tbs_used_info.used_of_max||'%'used_of_max_pctfrom (selecta.tablespace_name,
round(a.bytes_alloc/1024/1024) alloc_mb,
round((a.bytes_alloc-nvl(b.bytes_free,
0)) /1024/1024) used_mb,
round((a.bytes_alloc-nvl(b.bytes_free,
0)) *100/a.maxbytes) used_of_max,
round((a.maxbytes-a.bytes_alloc+nvl(b.bytes_free,
0)) /1048576) free_of_max_mb,
round(a.maxbytes/1048576) max_mbfrom (selectf.tablespace_name,
sum(f.bytes) bytes_alloc,
sum(decode(f.autoextensible,
'YES',
f.maxbytes,
'NO',
f.bytes)) maxbytesfromdba_data_filesfgroupbytablespace_name) a,
               (selectf.tablespace_name,
sum(f.bytes) bytes_freefromdba_free_spacefgroupbytablespace_name) bwherea.tablespace_name=b.tablespace_name(+)) tbs_used_infoorderbytbs_used_info.used_of_maxdesc;