Tuesday, July 14, 2009

TEMP table space and usage

Query to findout the usage and free space on TEMP tablespace:
SELECT tablespace_name, SUM(bytes_used)/1024/1024/1024, SUM(bytes_free)/1024/1024/1024 from v$temp_space_header GROUP BY tablespace_name;

Query to findout temp file locations:
select file_name,sum(bytes)/1024/1024/1024 from dba_temp_files group by file_name;

No comments:

Post a Comment