Re: Unix script to monitor iostat on AIX 4.3.3

I try doing this

while true

 do

  iostat 50 1|sed 1,3d | awk '{ printf("%s ,%s ,%s\n", $1, $5, $6)}'|\

   while read HDISK VMSTAT_IO_R VMSTAT_IO_W

    do

     if (echo $HDISK|grep -cq hdisk );then

      $ORACLE_HOME/bin/sqlplus internal <<EOF

       insert into stats\$iostat values

         (SYSDATE, 5, '$HDISK', $VMSTAT_IO_R,$VMSTAT_IO_W);        exit

      EOF      fi

    done

 done

I get no result. It just hangs. The perfstat table has been created but it doesn't populate.

Plz help

Rgds

--
Posted via http://dbforums.com