scripts/LJCOPY/DP/DEV/ts1.ksh

#!/bin/ksh
function get_db_size
{
res=`sqlplus -s expman/expdp@${ORACLE_SID} <<-EOF
        SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
        column bytes format 9999999
        select round(sum(bytes)/1024/1024/1024) from dba_extents;
        exit
EOF`
echo ${res}
}


# ---------------
export ORACLE_SID=${1}

DB_SIZE=`get_db_size`
echo "DB_SIZE is ${DB_SIZE}."  > /home/oracle/Scripts/DP/TS1.log

if [[ ${DB_SIZE} -gt 10 ]]
then
   echo "${ORACLE_SID} DB greater than 10GB......" >> /home/oracle/Scripts/DP/TS1.log
else
   echo "${ORACLE_SID} DB less than 10GB......"    >> /home/oracle/Scripts/DP/TS1.log
fi