tkprof steps

How to take tkprof

Step 1: 

source db environment file and go to

/u01/TEST/db/tech_st/12.1.0/admin/TEST_r12fwtest/diag/rdbms/test/TEST/trace

Step 2: 

Syntax


tkprof source.trc /u01/***/***.prf explain=apps/******* sys=no sort='(prsela, exeela, fchela)' 

tkprof TEST_ora_20967_CHAINSYS.trc /u01/scripts/TEST_ora_20967_CHAINSYS.prf explain=apps/******* sys=no sort='(prsela, exeela, fchela)'