TKPROF lists the statistics for a SQL statement
returned by the SQL Trace facility in rows and columns. Each row
corresponds to one of three steps of SQL statement processing.
Statistics are identified by the value of the CALL
column. See
Table 20-3.
Table 20-3 CALL Column Values
| CALL Value | Meaning |
|---|---|
|
|
Translates the SQL statement into an execution plan, including checks for proper security authorization and checks for the existence of tables, columns, and other referenced objects.翻译sql语句到执行计划,包括适当的安全性检查,并且检查表,字段,其它参考的对象是否存在。 |
|
|
Actual execution of the statement by Oracle. For
|
|
|
Retrieves rows returned by a query. Fetches are only performed
for |
The other columns of
the SQL Trace facility output are combined statistics for all
parses, all executes, and all fetches of a statement. The sum of
query and current is the total number of
buffers accessed, also called Logical I/Os (LIOs). See
Table 20-4.
Table 20-4 SQL Trace Statistics for Parses, Executes, and Fetches.
Statistics about the processed rows appear in the
ROWS column. See
Table 20-5.
Table 20-5 SQL Trace Statistics for the ROWS Column
| SQL Trace Statistic | Meaning |
|---|---|
|
|
Total number of rows processed by the SQL statement. This total does not include rows processed by subqueries of the SQL statement. sql语句处理的总行数。这个总行数不包括子查询处理的行数。 |
For SELECT statements, the number of rows returned
appears for the fetch step. For UPDATE,
DELETE, and INSERT statements, the number
of rows processed appears for the execute step.
对于SELECT语句,总行数在fetch这一步获得。对于PDATE,
DELETE, and
INSERT语句,总行数在execute这一步获得。
Note:
The row source counts are displayed when a cursor is closed. In SQL*Plus, there is only one user cursor, so each statement executed causes the previous cursor to be closed; therefore, the row source counts are displayed. PL/SQL has its own cursor handling and does not close child cursors when the parent cursor is closed. Exiting (or reconnecting) causes the counts to be displayed.参考:http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm#PFGRF01020
插入表情