What is tkprof and how is it used?


  • Tkprof is a performance diagnosing utility available to DBAs. It formats a trace file into a more readable format for performance analysis. So that the DBA can identify and resolve performance issues like poor SQL, indexing, and wait events.
  • When a user comes across problems related to the response time in comparison to his previous weeks response time, Session tracing and tkprof can be used to see exactly what is happening on the database, enabling the DBA to take corrective action.
  • At times, viewing SQL that is being executed for an application will be the only mechanism a DBA will have. These situations arrive during the execution of encrypted PL/SQL code on the database or submission of SQL statements from third party applications.