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

Keywords

filename1

Input SQL trace file.

filename2

Filename for output of TKPROF.

WAITS

Specifies whether to record summary for wait events. New with Oracle9i.

SORT

Sorts SQL statements in descending order for the listed options. Values for these options are:

PRSCNT

number of times parsed

PRSCPU

CPU time spent parsing

PRSELA

elapsed time spent parsing

PRSDSK

number of disk reads during parsing

PRSQRY

number of consistent mode block reads during parsing

PRSCU

number of current mode block reads during parsing

PRSMIS

number of library cache misses during parsing

EXECNT

[pnumber of times statement is executed

EXECPU

CPU time spent executing

EXEELA

elapsed time spent executing

EXEDSK

number of disk reads during execution

EXEQRY

number of consistent mode block reads during execution

EXECU

number of current mode block reads during execution

EXEROW

number of rows processed during execution

EXESMIS

number of library cache misses during execution

FCHCNT

number of fetches

FCHCPU

CPU time spent fetching

FCHELA

elapsed time spent fetching

FCHDSK

number of disk reads during fetch

FCHQRY

number of consistent mode block reads during fetch

FCHCU

number of current mode block reads during fetch

FCHROW

number of rows fetched

Tip

Consistent mode block reads are done for SELECT statements and do not place locks on the data. Current mode block reads are done for writes to the database and do ...

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