Wednesday, November 21, 2007

Calculate free space in TEMP tablespace

select tablespace_name, SUM(bytes_used), sum(bytes_free)
from v$temp_space_header
where tablespace_name = ‘TEMP’
group by tablespace_name;

No comments: