Temp Space Check

select * from v$temp_space_header;


SELECT (USED_BLOCKS * 8192 ) "used" , (FREE_BLOCKS * 8192) "free" ,(MAX_USED_BLOCKS * 8192 ) "maxused"
FROM v$sort_segment;


SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name;


SQL> set lines 152
col FreeSpaceGB format 999.999
col UsedSpaceGB format 999.999
col TotalSpaceGB format 999.999
col host_name format a30
col tablespace_name format a30
select tablespace_name,
(free_blocks*8)/1024/1024 FreeSpaceGB,
(used_blocks*8)/1024/1024 UsedSpaceGB, 
(total_blocks*8)/1024/1024 TotalSpaceGB,
i.instance_name,i.host_name
from gv$sort_segment ss,gv$instance i where ss.tablespace_name in (select tablespace_name from 
dba_tablespaces where contents='TEMPORARY') and
i.inst_id=ss.inst_id;


col tablespace_name for a20
col FILE_NAME for a35
select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024/1024 from dba_temp_files;