• Trace a Concurrent Request And Generate TKPROF File « Thirst for Oracle !!!
  Another example: To get (TKPROF) sorted by longest running queries first and limits the results to the “Top 10″ long running queries $ tkprof raw_trace_file.trc output_file sys=no explain=apps/ sort=’(prsela,exeela,fchela)’ print=10 Usage: tkprof
  in Oracle > Optimization with exeela explain fchela longest print prsela running tkprof usage

prsela from all users