After processing multiple trace files with tkprof you can sort them by number of seconds it took to execute queries, the potential problematic queries will appear at the bottom: grep ^total *.trc.txt | sort -k 4 -n
© 2005 tiplib.com