http://netvouz.com/MondoTofu/tag/longest?feed=rss MondoTofu's bookmarks tagged "longest" on Netvouz http://fshaikh.wordpress.com/2011/01/09/trace-a-concurrent-request-and-generate-tkprof-file/ 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 Oracle > Optimization MondoTofu Wed, 10 Sep 2014 02:37:18 GMT