#!/bin/bash

orasid=$1
export ORACLE_SID=${orasid}
_orasid0=${orasid:0:${#orasid}-1}
_orasid1=${orasid:${#orasid}-1:${#orasid}}


#
# check for digits only
#
function is_digit
{
echo $1|gawk ' { if ($0 ~ /^[0-9]+$/)
                    print 1
                  else
                    print 0 } '
} # end is_digit




OH=`/usr/local/bin/dbhome $orasid`
if [ "$?" != 0 ] && [ $(is_digit $_orasid1) == 1 ]
then
        OH=`/usr/local/bin/dbhome $_orasid0`
        if [ "$?" != 0 ]
        then
                echo "error: cannot find ${orasid} or ${_orasid0} in oratab file."
                exit
        else
                echo "using ${OH} for SID ${_orasid0} found in oratab."
                export ORACLE_HOME=$OH
        fi
else
        echo "using ${OH} for SID ${orasid} found in oratab."
        export ORACLE_HOME=$OH
fi

echo $ORACLE_SID
echo $ORACLE_HOME

sqlfile=/home/oracle/dpmon/refresh_tablespace_chart.sql
rptfile=/var/log/oracle/${orasid}_tablespace_usage.rpt

echo $rptfile

$ORACLE_HOME/bin/sqlplus dp_mon/Se4#naUpYr << EOS > $rptfile
set serveroutput on size 1000000
exec dp_adm.dp_monitor.refresh_tablespace_chart;
select * from dp_adm.tablespace_chart;
EOS

exit
