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