#!/bin/ksh
exec > /tmp/log.$$
sqlplus -s system/manager@dbname << EOF
select count(*) from dba_objects
/
exit
EOF
mailx -s "db report" yourself < /tmp/log.$$