Almost exactly my preferences. I tend to add in a record=sqlfilename as well. I find this can help me understand the transactions a wee bit better often.
To the OP what Daniel's command will give you is user issued SQL (i.e no recursive sql) in descending elapsed time order (the sort effectively means sort by the sum of these 3 not by each in turn) and with wait information detailed (assuming you captured it in the trace).
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
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:
-- Niall Litchfield Oracle DBA http://www.orawin.info