show tablespace usages status
set linesize 300 SELECT upper(f.tablespace_name) "tablespace_name",
- d.Tot_grootte_Mb "tablespace(M)", d.Tot_grootte_Mb - f.total_bytes "used(M)", round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100,2) "use%", f.total_bytes "free_space(M)", round(f.total_bytes / d.Tot_grootte_Mb * 100,2) "free%"
- FROM
- (SELECT tablespace_name,
- round(SUM(bytes)/(1024*1024),2) total_bytes, round(MAX(bytes)/(1024*1024),2) max_bytes
- FROM sys.dba_free_space
- GROUP BY tablespace_name) f,
- FROM sys.dba_data_files dd GROUP BY dd.tablespace_name) d
- (SELECT tablespace_name,
WHERE d.tablespace_name = f.tablespace_name ORDER BY 4 DESC /