First page Back Continue Last page Graphics

TKPROF Utility…


Notes:

The TKPROF utility converts the raw trace dump file into more readable / understandable format. TKPROF is executed at the OS command prompt.
Syntax notes:
infile - specifies the input trace file. The file can contain trace from one session or appended trace stats for many sessions.
outfile - output file name.
SYS - Displays (SYS) or suppresses display (NOSYS) of recursive (Oracle-generated) SQL statements generated by SYS. Often, setting SYS=NO is desired, because reading through tons of recursive SQL will not always help tune the query. However, a situation when viewing trace data on recursive SQL might be helpful is when constraint validation is causing a performance problem.
SORT - Sorts the traced SQL statements in descending order of the specified sort option. By default, TKPROF lists statements in chronological order. For example, you can specify SORT=EXEELA to list statements with the largest elapsed time first in the output file.
Refer to the Oracle9i Database Performance Tuning Guide and Reference for detailed information on the TKPROF parameters.