Multiple choice

TKPROF is ________.

  1. a utility that enables SQL code to run faster

  2. used to format the trace file generated by SQL_TRACE

  3. a diagnostic tool used to capture operating system statistics

  4. a utility used to capture the statistics of all SQL currently running in the database
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TKPROF is a Oracle utility that formats and interprets raw trace files generated by SQL_TRACE. The raw trace file is binary and hard to read directly. TKPROF converts it into human-readable format showing execution statistics, SQL statements, and timing information for performance analysis.

Keep practicing — related questions