The TKPROF Interpretation Script

---

Tip 

Please do not use this script without testing.

#!/bin/ksh     #execute profile – for example .cshrc     explain=$1 #set the explain variable to a non-null value if    required.     if [ –d /tmp/tkprof ]; then sleep 0; else mkdir    /tmp/tkprof; fi     if [ –z "$explain" ]; then           ls –lat $ORACLE_TRACE/$ORACLE_SID*.trc\       | awk '{print $9}'\       | awk –F/ '{print $8}'\       | awk –F. '{\             printf("tkprof %s/%s.trc\             /tmp/tkprof/%s.prf\n",oracle_trace,$1,$1)\       }' oracle_trace=$ORACLE_TRACE else       ls –lat $ORACLE_TRACE/$ORACLE_SID*.trc\       | awk '{print $9}'\       | awk –F/ '{print $8}'\       | awk –F. '{\             printf("tkprof %s/%s.trc /tmp/tkprof/%s.prf\             explain=<owner>/<password>                table=<owner>.plan_table\             sys=no record=/tmp/tkprof/%s.rec\n",                 oracle_trace,$1,$1,$1)\       }' oracle_trace=$ORACLE_TRACE     fi     ls –lat /tmp/tkprof/$ORACLE_SID*.prf\ | awk '{ printf("perl tkprof.pl %s\n",$9) }' exit 0

---