health_check_script

==================================================health_check_script===============================================
set pagesize 20000
set linesize 180
set pause off
set serveroutput on
set feedback on
set echo on
set numformat 999999999999999
Spool healthcheck.lst
select tablespace_name, sum(bytes/1024/1024) as "FREE MB" from dba_free_space group by tablespace_name;
select tablespace_name, sum(bytes/1024/1024) as "USED MB" from dba_data_files group by tablespace_name;

spool off