]Sent: Tuesday, January 21, 2003 6:29
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
question on tkprof
First, always use the SORT= option to generate TKPROF output -- the
utility is useless if you don't sort the output. For sorting, I have two
suggestions:
As a test I took a *trc file generated on a V7.3.4.5 DB and
copied it to a system where I have a "dataless" 9i copy of the
same DB. I used TKPROF from 9i & got all the wait statistics
reported along with the relevant EXPLAIN PLAN!
HTH & YMMV
HAND!
--
Please see the official ORACLE-L FAQ:
Three options:
* use the "Hotsos Profiler" trace analysis tool from
http://www.hotsos.com
* use the "itrprof" trace analysis tool from
http://www.ubtools.com
* copy a TKPROF executable from an Oracle9i release
and run (through SQL*Net!) against your earlier databas
Tim Gorman,
hi, in oracle 9i there is waits=y to print the wait time in the
tkprofed file, but in 7-8i, tkprof does not support this option.
Is there any script that can generate the wait time from the 10046 trace file?
Thanks.
Regards
zhu chao
msn:[EMAIL PROTE
First, always use the SORT= option to generate TKPROF output -- the utility
is useless if you don't sort the output. For sorting, I have two
suggestions:
* sort by "logical reads" (i.e.
SORT=EXEQRY,FCHQRY,EXECU,FCHCU)
* sort by "elapsed time" (i.e.
SORT=PRSELA,FCHELA,EXEELA)
If