Ich würde gern das ergebnis diese skript in eine Email od SMS an mich senden lassen. HAt jemand eine Idee?
SELECT s.tablespace_name tsname , TO_CHAR(s.tsfree/1024, '999,999,990') tsfree , TO_CHAR(f.tssize/1024, '999,999,990') tssize , TO_CHAR(100-((s.tsfree / f.tssize)*100), '990')||'%' pctused FROM (SELECT tablespace_name , SUM (bytes) tsfree FROM dba_free_space GROUP BY tablespace_name ) s , (SELECT tablespace_name , sum (bytes) tssize FROM dba_data_files GROUP BY tablespace_name ) f WHERE s.tablespace_name = f.tablespace_name UNION SELECT '__Overall sum__' , TO_CHAR(SUM(s.tsfree)/1024, '999,999,990') tsfree , TO_CHAR(SUM(f.tssize)/1024, '999,999,990') tssize , TO_CHAR(100-((SUM(s.tsfree) / SUM(f.tssize))*100), '990')||'%' pctused FROM (SELECT tablespace_name , SUM (bytes) tsfree FROM dba_free_space GROUP BY tablespace_name ) s , (SELECT tablespace_name , sum (bytes) tssize FROM dba_data_files GROUP BY tablespace_name ) f WHERE s.tablespace_name = f.tablespace_name /