sql_trace

hi friend i have 1 query
that is
using sql_trace=true
or
alter session set sql_trace=true
you can find out the query execution performance

but in case there is so many user then how can you find out that perticular user query is this

for example

user_dump_dest=/oracle/udump/

filename                  username(i am adding for understanding)
file1.trc                        hr
file2.trc                        sales
file3.trc                        sales

using abouve files suppose you need to find out users hr executed query

how will you find out this?

adavantage of this

if there is thousands of user then it become very difficult for dba to trace aparticular user detail

and for him difficult to trace further using trace

i want output like this
username executed qu

 filename                                    username
oracle/udump/file1.trc                     hr
oracle/udump/file4.trc                     hr
oracle/udump/file1.trc                     hr
oracle/udump/file1.trc                     hr

so that i can user
tkprof oracle/udump/file1.trc

this is good for handy work of tkprof Received on Fri Apr 20 2007 - 01:34:34 CDT