#!/bin/ksh -x
. $HOME/.profile_DB
$ORACLE_HOME/bin/sqlplus /NOLOG <<HERE
-- Exit with failure, if SQL, PL/SQL or OS error is raised in top level proc
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
CONNECT oracle/DREAMZ
#----------------------------------------------------------------------------------------------------------------
print    "\n---  Reporting FREE Space in Tablespaces  ---  \n">>$STATS_LOG

$ORACLE_HOME/bin/sqlplus /NOLOG <<HERE
-- Exit with failure, if SQL, PL/SQL or OS error is raised in top level proc
WHENEVER SQLERROR EXIT FAILURE;
 WHENEVER OSERROR EXIT FAILURE;
--
#-----------------------------------------------------------------------------------------------------------------
print    "\n--- Reporting MOUNT POINT Disk Space Usage (df -lk)  ---  \n">>$STATS_LOG

df -lk >> $STATS_LOG

retcode=$?
if [ $retcode != '0' ]; then
   print "FATAL ERROR: Reporting MOUNT POINT Disk Space Usage... failed: status $retcode; ERRNO $ERRNO \n">>$STATS_LOG
   ERROR_FLG='1'
else
   print "\n---  Reporting MOUNT POINT Disk Space Usage (df -lk)... COMPLETED!  ---  \n">>$STATS_LOG
fi