selecta.tablespace_name,
a.bytes/1024/1024"sum MB",
(a.bytes-b.bytes)/1024/1024"used MB",
b.bytes/1024/1024"free MB",
round(((a.bytes-b.bytes)/a.bytes)*100,
2)"percent_used"from(selecttablespace_name,
sum(bytes)bytesfromdba_data_filesgroupbytablespace_name)a,
(selecttablespace_name,
sum(bytes)bytes,
max(bytes)largestfromdba_free_spacegroupbytablespace_name)bwherea.tablespace_name=b.tablespace_nameorderby((a.bytes-b.bytes)/a.bytes)desc;
a.bytes/1024/1024"sum MB",
(a.bytes-b.bytes)/1024/1024"used MB",
b.bytes/1024/1024"free MB",
round(((a.bytes-b.bytes)/a.bytes)*100,
2)"percent_used"from(selecttablespace_name,
sum(bytes)bytesfromdba_data_filesgroupbytablespace_name)a,
(selecttablespace_name,
sum(bytes)bytes,
max(bytes)largestfromdba_free_spacegroupbytablespace_name)bwherea.tablespace_name=b.tablespace_nameorderby((a.bytes-b.bytes)/a.bytes)desc;