Wednesday, November 28, 2007

Checking tempspace usage

SELECT tablespace_name, SUM(bytes_used), SUM(bytes_free)
FROM V$temp_space_header
GROUP BY tablespace_name
/
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)