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 ...