Comprobar el estado de los tablespace en Oracle

SELECT tablespace_name,SUM(bytes)/1024/1024, SUM(blocks)

FROM dba_temp_files

GROUP BY tablespace_name