Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page