Understanding TKProf output

In the previous post (Oracle TKProf Usage), we saw how to generate a SQL Trace and then how to format it using TKProf. In that post we create a trace for following SQL statement:- select * from all_objects; In this post we would interpret TKProf output of that SQL query. Following is the TKProf Output…

Oracle TKProf Usage

The TKProf facility accepts as input a SQL trace file and produces a formatted output file. TKPROF filename_source filename_output EXPLAIN=[username/password] SYS=[YES/No] TABLE=[tablename] filename_source: The trace file that needs to be formatted.filename_output: The output file where the formatted file will be written.EXPLAIN: This option causes TKProf to generate an execution plan for each SQL statement in…