December 2002
Intermediate to advanced
928 pages
85h 29m
English
The EXPLAIN PLAN statement can help you to understand what execution paths were used for individual SQL statements. TKPROF is used in conjunction with files created by the SQL Trace utility, which collects information about SQL statements that have been executed. The TKPROF utility formats information gathered by SQL Trace into a readable format.