Question

What is SQL Trace and what are the steps for generating Trace file?

Answer 1

Step 3: Formatting Trace Files with TKPROF. TKPROF accepts as input a trace file produced by the SQL Trace facility, and it produces a formatted output file. TKPROF can also be used to generate execution plans. ... Run TKPROF on each individual trace file, producing a number of formatted output files, one for each session.