Oracle in a Nutshell

TKPROF Output

The output from TKPROF contains the following items:

• The SQL statement.

• Statistics for the statement. There are three lines of statistics for each SQL statement: parse, execute, and fetch, as listed in the call column of the output. For each of these lines are seven additional fields in the following columns:

  count

  Number of times the step was performed

  cpu

  Total CPU time for the step

  elapsed

  Elapsed time for the step

  disk

  Number of disk blocks read

  query

  Number of buffers accessed in consistent mode, which is used for SELECT operations and does not apply to locks

  current

  Number of buffers accessed in current mode, which is used for INSERT, UPDATE, and DELETE operations and applies to locks

  rows

  Number of rows processed by the SQL statement

These three rows are followed by a summary row with the totals for all three phases:

• Information about the statement’s execution. This information can include the number of library cache misses in each portion of the call, the optimizer goal for the statement, and the ID of the user executing the statement. If there are no library cache misses, this information is not reported.

• The execution plan, if specified in the command-line argument.

The TKPROF report begins with information on any SQL statements that generated an error and ends with a summary of all of the information presented, divided into nonrecursive SQL statements and recursive SQL statements. The summary also includes information about the trace file used to generate the report. ...