Shell Programming and Scripting

[dba@server_1 scripts]$ cat script.sh
#!/bin/bash
. /home/dba/.bash_profile

cd /u01/session
rm created_objects.html



for DB in database_1
do

    export ORACLE_SID=$DB
    export ORACLE_HOME=`grep $DB /etc/oratab | awk -F ":" {'print$2'}`

    $ORACLE_HOME/bin/sqlplus -s "/ as sysdba" << EOF
    set markup html on spool on
    spool /u01/session/created_objects.html
    set linesize 200
    col machine for a45
    col username for a15
    col program for a35
    set feedback off
    set head on


    SELECT count(1) AS connection_count, machine, username, osuser, program
    FROM v\$session
    WHERE type <> 'BACKGROUND'
    GROUP BY username, machine,  osuser, program
    ORDER BY connection_count DESC;


    spool off;

    EOF

done

echo >> created_objects.html

mail -s "$(echo -e "Newly Created Objects\nContent-Type: text/html")" email@mail.com < /u01/session/created_objects.html

(
echo "To: me@example.com"
echo "Subject: hello"
echo "Content-Type: text/html"
echo
cat /u01/session/created_objects.html
echo
) | /usr/sbin/sendmail -t