What is difference between Explain plan & TKProf?
Printable View
What is difference between Explain plan & TKProf?
Explain plan displays the output of the plan at sql prompt itself in sql * plus . tkprof creates a separate report file in text format . There is difference in output of both.
[QUOTE=babi_geek;28772]What is difference between Explain plan & TKProf?[/QUOTE]
u can find clear explanation [URL="http://www.dbspecialists.com/presentations/use_explain.html"]here[/URL]
EXPLAIN PLAN is a statement that allows you to have Oracle generate the execution plan for any SQL statement without actually executing it. You will be able to examine the execution plan by querying the plan table.
A plan table holds execution plans generated by the EXPLAIN PLAN statement.
TKPROF is a utility provided by Oracle that formats SQL trace files into very helpful and readable reports. TKPROF is installed automatically when the database server software is installed. You invoke TKPROF from the operating system command line; there is no graphical interface for TKPROF