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
SELECT tablespace_name,SUM(bytes)/1024/1024, SUM(blocks)
FROM dba_temp_files
GROUP BY tablespace_name