Shell Programming and Scripting

#!/bin/sh
. /home/.profile

sqlplus -s $LOGON << .eof > $scripts/check_tablespace.temp
set pages 0
select tablespace_name, free_percent
from (
            SELECT b.tablespace_name, b.tablespace_size_mb, sum(nvl(fs.bytes,0))/1024/1024 free_size_mb,
            (sum(nvl(fs.bytes,0))/1024/1024/b.tablespace_size_mb *100) free_percent
            FROM dba_free_space fs,
                 (SELECT tablespace_name, sum(bytes)/1024/1024 tablespace_size_mb FROM dba_data_files
                  GROUP BY tablespace_name
                 ) b
           where
           fs.tablespace_name like 'INFA_%'
           and
           fs.tablespace_name = b.tablespace_name
           group by b.tablespace_name, b.tablespace_size_mb
        ) ts_free_percent
WHERE free_percent < 60
ORDER BY free_percent;
exit
eof

cd $scripts
chmod ugo+rw check_tablespace.temp
counter=`cat check_tablespace.temp | sed '/^$/d'| wc -l`
echo "count="$counter
if [ $counter -gt 0 ] then
   cat check_tablespace.temp | mailx -s 'Alert: Free tablespace alert' $alertlist
fi
rm check_tablespace.temp

cat: cannot open check_tablespace.temp

cat check_tablespace.temp
INFA_TS                        45.575

$scripts/check_tablespace.temp

/check_tablespace.temp

cd $scripts

cd

. /home/.profile

sqlplus -s $LOGON << .eof > ...
...
.eof