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)'
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)'
No comments:
Post a Comment