Shell Programming and Scripting

#!/bin/ksh

file_to_search="x.txt"
search1="CREATE INDEX"
#search1="DROP INDEX"
grep -in "^${search1}" ${file_to_search} > x.ksh.tmp.00
num_lines=`wc -l x.ksh.tmp.00 | awk '{ print $1 }'`
#echo "num_lines = $num_lines"

count=0
while read line
do
   let count=$count+1
   create_index_txt=`sed -n ${count}p x.ksh.tmp.00 | awk -F: '{ print $2 }'`
   start=`sed -n ${count}p x.ksh.tmp.00 | awk -F: '{ print $1 }'`

   if [[ $count -eq $num_lines ]] ; then
      end=`wc -l ${file_to_search} | awk '{ print $1 }'`
   else
      let x=$count+1
      end=`sed -n ${x}p x.ksh.tmp.00 | awk -F: '{ print $1 }'`
   fi

   echo "- Searching timing for - [ $create_index_txt ] within --> start = $start // end = $end"
   elapsed=`sed -n ${start},${end}p ${file_to_search} | grep -i "^elapsed:" | head -1`
   echo "     Elapsed = ${elapsed}"
done < x.ksh.tmp.00

15:CREATE INDEX ABC.TESTCCB_XYZ_SOLD_B7
33:CREATE INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3
51:CREATE INDEX ABC.TESTCCB_XYZ_VAT_B1
56:CREATE INDEX ABC.TESTCCB_XYZ_VAT_B1
66:CREATE INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3
81:CREATE INDEX ABC.TESTCCB_XYZ_VAT_B3
96:CREATE INDEX ABC.TESTCCB_XYZ_SOLD_B3
111:CREATE INDEX ABC.TESTCCB_XYZ_TRIP_B3
126:CREATE INDEX ABC.TESTCCB_XYZ_XXX_B3
141:CREATE INDEX ABC.TEST_XYZ_VAT_B3
156:CREATE INDEX ABC.TEST_XYZ_SOLD_B3
171:CREATE INDEX ABC.TEST_XYZ_REASON_B3
186:CREATE INDEX ABC.TEST_XYZ_TRIP_B3
201:CREATE INDEX ABC.TEST_XYZ_XXX_B3
216:CREATE INDEX ABC.TEST_XYZ_CRAP_CON_B3
231:CREATE INDEX ABC.TEST_XYZ_ERROR_B3
236:CREATE INDEX ABC.TEST_XYZ_ERROR_B3
246:CREATE INDEX ABC.TEST_XYZ_COM_END_B3
261:CREATE INDEX ABC.TEST_XYZ_COM_B3
276:CREATE INDEX ABC.TEST_XYZ_SUB_INFO_B3

sed -n ${start},${end}p ${file_to_search} | grep -i "^elapsed:" | head -1

04-SEP-15 15:45:24

Elapsed: 00:00:00.01
DOC>* Script to create indexes
DOC>*/
DROP INDEX ABC.TESTCCB_XYZ_SOLD_B7
DROP INDEX ABC.TESTCCB_XYZ_SOLD_B7
               *
ERROR at line 1:
ORA-01418: specified index does not exist


Elapsed: 00:00:00.00
CREATE INDEX ABC.TESTCCB_XYZ_SOLD_B7

Index created.

Elapsed: 00:16:15.54
ALTER INDEX ABC.TESTCCB_XYZ_SOLD_B7

Index altered.

Elapsed: 00:00:00.03
DROP INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3
DROP INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3
               *
ERROR at line 1:
ORA-01418: specified index does not exist


Elapsed: 00:00:00.00
CREATE INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3

Index created.

Elapsed: 00:31:17.98
ALTER INDEX ABC.TESTCCB_XYZ_CRAP_CON_B3

Index altered.

Elapsed: 00:00:00.04
DROP INDEX ABC.TESTCCB_XYZ_VAT_B1
DROP INDEX ABC.TESTCCB_XYZ_VAT_B1
               *
ERROR at line 1:
ORA-01418: specified index does not exist


Elapsed: 00:00:00.01
CREATE INDEX ABC.TESTCCB_XYZ_VAT_B1

Index created.

Elapsed: 00:18:15.82
CREATE INDEX ABC.TESTCCB_XYZ_VAT_B1

Index altered.

sed -n ${start},${end}p ${file_to_search}x.ksh.tmp.00 | grep -i "^elapsed:" | head -1

file_tmp=x.ksh.tmp.00