tkprof and statemnet execution time

I am trying to collect information about all the SQL statments run against my instance AND the order in which they are executed (we have a canned application and no idea what SQL it is running). I have the database in trace mode, and it is generating *trc files, but

I have the following problems:

1. TKPROF does not give me an execution time of a statement (ie when it ran) it only tells me how long it ran for
2. TKPROF does not tell me the value of bind variables (so I can rerun the statement)

It appears that the trace files that tkprof digests have some time value in them, but where does it go? Also I have 100's of trace files with very similar date stamps, so I how do I determine the order in which the sql was run between the different trace files (I am assuming that in one trace file the SQL is in the correct order) on my instance?

Any help would be great!

Runing on
Oracle 8.1.7, on Linux

Pat
patrick.doran_at_synchronoss.com Received on Sun Jan 19 2003 - 16:40:32 CST