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. ...