Showing posts with label FIND THE FREE SPACE IN ORACLE. Show all posts
Showing posts with label FIND THE FREE SPACE IN ORACLE. Show all posts

Saturday, April 2, 2011

FIND THE FREE SPACE IN ORACLE


Select TABLESPACE_NAME,
sum (BYTES) Total_free_space,
max (BYTES) largest_free_extent
From dba_free_space
Group by TABLESPACE_NAME