SQL Trace, TKPROF and Autotrace - Oracle PL SQL Course - Lesson 30 | SQL courses

Duration: 18:18 min

Summary: The Oracle server has many types of traces that allow the capture of the state, configuration, parameters and SQL statements executed on Oracle. This video explains how to capture a simple trace in order to analyze the execution plan and other statistics from the SQL statements sent to Oracle. Since the ouput file of the SQL trace is not in a human-readable format, the TKPROF tool is used to format the trace in a meaningful report. The video also show a simple example of how to enable the autotrace feature on the sqlplus tool to gather statistics and the execution plan of SQL statements.