- select T1.TABLESPACE_NAME,
- T1.BYTES bytes_used,
- T2.BYTES bytes_free,
- T2.largest,
- round(((T1.BYTES-T2.BYTES)/T1.BYTES)*100,2) percent_used
- from
- (
- select TABLESPACE_NAME,
- sum(BYTES) BYTES
- from dba_data_files
- group by TABLESPACE_NAME
- )
- T1,
- (
- select TABLESPACE_NAME,
- sum(BYTES) BYTES ,
- max(BYTES) largest
- from dba_free_space
- group by TABLESPACE_NAME
- )
- T2
- where T1.TABLESPACE_NAME=T2.TABLESPACE_NAME
- order by ((T1.BYTES-T2.BYTES)/T1.BYTES) desc
select T1.TABLESPACE_NAME,
T1.BYTES bytes_used,
T2.BYTES bytes_free,
T2.largest,
round(((T1.BYTES-T2.BYTES)/T1.BYTES)*100,2) percent_used
from
(
select TABLESPACE_NAME,
sum(BYTES) BYTES
from dba_data_files
group by TABLESPACE_NAME
)
T1,
(
select TABLESPACE_NAME,
sum(BYTES) BYTES ,
max(BYTES) largest
from dba_free_space
group by TABLESPACE_NAME
)
T2
where T1.TABLESPACE_NAME=T2.TABLESPACE_NAME
order by ((T1.BYTES-T2.BYTES)/T1.BYTES) desc