Databases Reference
In-Depth Information
In the following screenshot, we can see an excerpt of the report generated by TKPROF :
In the results you can see a table showing different information related to the query.
The three phases required to execute the statement are reported in rows—Parse, Execute,
and Fetch. The parse step includes syntax and permission checks, and transforms the
statement into an execution plan. The execute step is the execution of the statement, and
the fetch step is the iteration over the returned rows.
For each phase, there are seven columns. They are as follows:
F count: The number of times the operation on the row (Parse, Execute, and Fetch)
is executed
F cpu: The total CPU time in seconds
F elapsed: The total elapsed time in seconds
F disk: The number of physical disk reads (from the datafiles)
F query: The number of buffers retrieved
F current: The number of buffers retrieved in current mode (for DML statements
UPDATE , INSERT , DELETE )
F rows: The number of rows returned
 
Search WWH ::




Custom Search