doc

    Name:   freespac.sql

    Author: Mark Gurry


The following script lists the amount of free disk space for each 
tablespace. Each extent is listed in descending size order. 

#

 SELECT TABLESPACE_NAME, BYTES
   FROM DBA_FREE_SPACE
  ORDER BY TABLESPACE_NAME, BYTES DESC;