Free space available for a user
Below query returns the free space available for the user in each tablespace.
SELECT tablespace_name, sum(bytes)/1048576 Megs
FROM user_free_space
GROUP BY tablespace_name
SELECT tablespace_name, sum(bytes)/1048576 Megs
FROM user_free_space
GROUP BY tablespace_name
No comments:
Post a Comment
Thanks