#!/bin/sh
#**************************************************************************************************
#
# Script Name: tkp
#
# Developed by Jay
#**************************************************************************************************
# This script get the trace file name as argument and creates a tkprof file required for oracle analysis
#
# Usage : tkp "oracle_trace_file"
#
# Assumption: The oracle home environment set properly 
#             The trace file suffix is .trc and is not provided as parameter argument
#             tkprof utility - unix - installed and oracle_home and path environment variables set
#             user id = apps, and password = apps
#**************************************************************************************************
if [ $@ > 0 ]
then
tkprof $1.trc $1.tkprof sort=exeela,fchela,prsela explain=apps/apps@PRODUCTION
else
echo 'Usage : tkp "oracle_trace_file"'
fi