How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]

How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]

TKPROF filename_source filename_output EXPLAIN=[username/password] SYS=[YES/No] TABLE=[tablename]

$tkprof raw_trace_file.trc output_file explain=apps/apps

sort=(exeela,fchela) sys=no

Where:

raw_trace_file.trc: Name of trace file

output_file:        tkprof out file

explain:            This option provides the explain plan for the sql  

                   statements

sort:               This provides the sort criteria in which all sql  

                   statements will be sorted.  This will bring the bad

sql at  

                   the top of the outputfile.

sys=no:             Disables sql statements issued by user SYS

TKPROF_APPS.htm For R12

TKPROF.htm For Database

tkprof  ERPP_ora_16286_i351307.trc output_file_name explain =apps/apps sys=no