| 123456789101112131415161718192021 |
- #!/bin/ksh
- export ORACLE_SID=${1}
- 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 9999
- select trim(round(sum(bytes)/1024/1024/1024)) from dba_extents;
- exit;
- EOF`
- echo "${ORACLE_SID} DB Size is -${res}-."
- if [[ ${res} -ge 10 ]]
- then
- echo "${ORACLE_SID} DB greater than 10GB......"
- else
- echo "${ORACLE_SID} DB less than 10GB......"
- fi
|
