Re: TKPROF

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: Wed, 6 Sep 2006 07:51:43 -0700 (PDT)
Message-ID: <20060906145143.67852.qmail@web37215.mail.mud.yahoo.com>

tkprof is an o/s command line utility, not a sql*plus command.

I prefer the call to be

tkprof <tracefile> <outputfile> sort=fchela,exeela,prsela waits=yes sys=no

For a complete list of options, call tkprof without any files/parameters.

Regards,
Daniel Fink

crcbedoy_at_proteccion.com.co wrote:
Hi all,

Does anybody know how to use the TKPROF command to format and analize a trace file generated by SQL?. I generated a trace file named: prt_ora_12733.trc, I am trying to get some detailed information because the trace file is quite big, but I get an error in SQLPLUS when I try to do the following:

TKPROF prt_ora_12733.trc output.prf

Isabel Bedoya Gómez
Centro de Gestión y Control
Tel. 2307500 ext:

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 06 2006 - 09:51:43 CDT