[ORACLE] INFOS TABLESPACE

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