-- name       : free_space.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show details of free space available in tablespaces
-- limitation : needs access to dba_free_space
--
-- useage     : SQL> @free_space

set pages 50
set feed off
set verify off
set linesize 200

spool free_space.lis

col sizing head "Sizing (MB)" for 999,999,999
col tablespace_name head "Tablespace Name" for a30

select 	sum(bytes/(1024*1024)) sizing,
	tablespace_name tablespace_name
from 	dba_free_space
group by tablespace_name
/

spool off

set pages 24
set feed on
set verify on
set lines 80