Set Feedback Off
Set Echo Off
Set Heading Off
Set Term Off

Column Instance New_Value _Instance NoPrint
SELECT 'OTF_' || name Instance FROM v$database;

spool &&_instance..txt;

-- Check TableSpace Free Space

select Tablespace_Name, 100*Sum_Free_Blocks/Sum_Alloc_Blocks
from
(select Tablespace_Name, SUM(Blocks) Sum_Alloc_Blocks
from DBA_DATA_FILES 
group by Tablespace_Name), 
   (select Tablespace_Name FS_TS_NAME,
   SUM(Blocks) AS Sum_Free_Blocks
   from DBA_FREE_SPACE
   group by Tablespace_Name)
where Tablespace_Name = FS_TS_NAME;

spool off;
Set Feedback On
Set Echo On
Set Heading On
Set Term On

exit;