HOW TO CREATE TKPROF FILE FROM A TRACE FILE IN IBM AIX SERVER FOR AN ORACLE APPLICATION FORM

In IBM Aix server system, you have to find firstly the directory of tkprof.sh file which is located under

ora_home/.../bin

How can i find tkprof.sh file ? That is so easy. Write the code as shown below to your console (Putty,SecureCRT...etc) providing connection to your server.

It will show up the directory where tkprof.sh is located.


Next step you will go into that directory with cd (change directory) command

To execute tkproof.sh and receive and output file from your trace file, you have a format which you have to carry out.That is ;


>tkprof  <full_path_of_trace_file> <output_file> explain=apps/apps_pwd sort='(prsela,exeela,fchela)'

But here one thing you have to be aware.

while executing an sh file you need to write './' at the head of file's name.

eg.--> ./tkprof <full_path_of_trace_file> <output_file> explain=apps/apps_pwd sort='(prsela,exeela,fchela)'

Then it will extract the file to the directory of tkprof.sh file.

Here we go.