First page Back Continue Last page Graphics
TKPROF Report
Several sections in TKPROF report
Header
- release and field descriptions
SQL statements and statistics
Overall Totals
- Non-Recursive statements
- All recursive statements
- Summary
Notes:
Take the time now to review the formatted trace file report.txt. Become familiar with the various sections within the report.
Supplemental Notes
Note that “non-recursive” statements are statements that were entered by the application or user. Recursive SQL is SQL that was within a PL/SQL block or generated by Oracle (SYS) on behalf of a user SQL statement. You’ll often see queries against the data dictionary such as:
select pos#,intcol#,col#,spare1,bo#,spare2
from
icol$ where obj#=:1
Oracle-generated recursive SQL such as this are often not helpful in SQL tuning and can be suppressed from the TKPROF output with the SYS=NO option. A situation when viewing trace data on recursive SQL might be helpful is when constraint validation is causing a performance problem.