UNIX 스크립트를 Windows *.bat 파일로 변환 구현 도움 부탁 드립니다.

#!/bin/ksh
 
. ~/.profile
 
#=========================================================================
# Defile Oracle SID 
#ORACLE_SID=`ps -ef | grep ora_pmon | grep -v grep | cut -f 3- -d _`
ORACLE_SID=DEVKSC
TBSP_DIR=/tbsp_mon
 
# Define Threshold
_TH5=97
_TH4=95
_TH3=90
_TH2=85
_TH1=80
 
_LV5='[CRITICAL]'
_LV4='[MAJOR]'
_LV3='[MINOR]'
_LV2='[WARNING]'
_LV1='[INFORMATION]'
 
# Define Check Time
_DT=`date "+%Y/%m/%d %H:%M:%S"`
 
# Define SQL output file
_OUTFILE=$TBSP_DIR/$ORACLE_SID/tbspall.out
 
# Define Tablespace Check result output file
_LOGFILE=$TBSP_DIR/$ORACLE_SID/tbspchk.out
#========================================================================
 
export $ORACLE_SID
 
{
sqlplus -s '/as sysdba' << EOF 
 
SET LINESIZE  145
SET PAGESIZE  9999
SET VERIFY    off
 
COLUMN A.TABLESPACE_NAME FORMAT A15
 
SELECT A.TABLESPACE_NAME,
       ROUND(A.BYTES_ALLOC / 1024 / 1024, 2) CURRENT_SIZE,
       ROUND(NVL(B.BYTES_FREE, 0) / 1024 / 1024, 2) FREE_SIZE,
       ROUND((A.BYTES_ALLOC - NVL(B.BYTES_FREE, 0)) / 1024 / 1024, 2) USED_SIZE,
       ROUND((NVL(B.BYTES_FREE, 0) / A.BYTES_ALLOC) * 100,2) FREE_RATE,
       100 - ROUND((NVL(B.BYTES_FREE, 0) / A.BYTES_ALLOC) * 100,2) USED_RATE,
       ROUND(MAXBYTES/1048576,2) MAX_SIZE
FROM   ( SELECT F.TABLESPACE_NAME,
       SUM(F.BYTES) BYTES_ALLOC,
       SUM(DECODE(F.AUTOEXTENSIBLE, 'YES',F.MAXBYTES,'NO', F.BYTES)) MAXBYTES
       FROM DBA_DATA_FILES F
       GROUP BY TABLESPACE_NAME) A,
       ( SELECT F.TABLESPACE_NAME,
                SUM(F.BYTES)  BYTES_FREE
         FROM DBA_FREE_SPACE F
         GROUP BY TABLESPACE_NAME) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME (+)
UNION
SELECT TABLESPACE_NAME,
       ROUND(SUM(BYTES_USED + BYTES_FREE) / 1048576, 2),
       ROUND(SUM(BYTES_FREE) / 1048576,2),
       ROUND(SUM(BYTES_USED) / 1048576,2),
       ROUND((SUM(BYTES_FREE) / SUM(BYTES_USED + BYTES_FREE)) * 100,2) FREE_RATE,
       100 - ROUND((SUM(BYTES_FREE) / SUM(BYTES_USED + BYTES_FREE)) * 100,2) USED_RATE,
       ROUND(MAX(BYTES_USED + BYTES_FREE) / 1048576, 2)
FROM   SYS.V_\$TEMP_SPACE_HEADER
GROUP BY TABLESPACE_NAME
ORDER BY 1;
 
EXIT;
EOF
} > $_OUTFILE
 
grep -v '^$' $_OUTFILE | egrep -v "^TABLESPACE_NAME|^-|selected" | awk '{print $1, $6}' | cut -d . -f 1 | while read _tn _us
do
  if [ "$_us" -ge "$_TH5" ]
  then
      echo $_tn ":" $_us "% ( >= "$_TH5"% ) "$_LV5  >> $_LOGFILE
 
  elif [ "$_us" -lt "$_TH5" ] && [ "$_us" -ge "$_TH4" ]
  then
      echo $_tn ":" $_us "% ( >= "$_TH4"% ) "$_LV4  >> $_LOGFILE
 
  elif [ "$_us" -lt "$_TH4" ] && [ "$_us" -ge "$_TH3" ]
  then
      echo $_tn ":" $_us "% ( >= "$_TH3"% ) "$_LV3  >> $_LOGFILE
 
  elif [ "$_us" -lt "$_TH3" ] && [ "$_us" -ge "$_TH2" ]
  then
      echo $_tn ":" $_us "% ( >= "$_TH2"% ) "$_LV2  >> $_LOGFILE
 
  elif [ "$_us" -lt "$_TH2" ] && [ "$_us" -ge "$_TH1" ]
  then
      echo $_tn ":" $_us "% ( >= "$_TH1"% ) "$_LV1  >> $_LOGFILE
  fi
done