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

No comments:

Post a Comment