1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
select T1.tablespace_name,
T1.bytes / 1024 / 1024 as "Espace utilisé (Mb)",
T2.bytes / 1024 / 1024 as "Espace libre (Mb)",
T2.largest /1024 /1024 as "Largest (Mb)",
round(((T1.bytes-T2.bytes)/T1.bytes)*100,2) as "Pourcentage_utilisé"
from
(
select tablespace_name,
sum(bytes) as bytes
from dba_data_files
group by tablespace_name
)
T1,
(
select tablespace_name,
sum(bytes) as bytes ,
max(bytes) as 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 ; |