Shell Programming and Scripting

#!/bin/bash
. /home/oracle/prod.env
echo " "
echo =======================================================================
echo archive_usage.sh:  $ORACLE_SID
echo To know the Archive/Db_recovery_area usage
date +"%A, %B %e, %r"
echo -----------------------------------------------------------------------
status=$(sqlplus -S system/PWD@$ORACLE_SID << ENDINP
set feedback off
set hea off
set verify off
SELECT METRIC_VALUE FROM SYS.DBA_OUTSTANDING_ALERTS where reason like '%db_recovery_file_dest_size%'
/
exit
ENDINP)
status=`echo $status`
echo "Archive Area usage is:" $status
if [ $status >= 80 ]; then
   mailx -s "PROD - Archive Area Usage is growing" "mjcprasad2000@gmail.com"
      Production PROD ARCHIVE Area is above 85%!!
   exit 1
else
mailx -s "PROD - Not in Thresholds" "mjcprasad2000@gmail.com"
   exit 0
fi

SELECT METRIC_VALUE FROM SYS.DBA_OUTSTANDING_ALERTS where reason like '%db_recovery_file_dest_size%'

if [ $status >= 80 ]; then

if [ $status -ge 80 ]; then

status=`echo $status`