Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Can I consolidate many trc file to one anf use tkprof to analyze it ?

xiongye_2
Occasional Advisor

Can I consolidate many trc file to one anf use tkprof to analyze it ?

Hi: I use weblogic connection pool to start 30 connection to Oracle , After use
dbms_system.set_sql_trace_in_session , I got 30 trc file , Can I consolidate these file in one to analyze ? Thanks!!
xysco
2 REPLIES
T G Manikandan
Honored Contributor

Re: Can I consolidate many trc file to one anf use tkprof to analyze it ?


for i in `ls `
do
cat $i >>xyz.trc
done
$ORACLE_HOME/bin/tkprof xyz.trc xyz.trc.ascii


Thanks
harry d brown jr
Honored Contributor

Re: Can I consolidate many trc file to one anf use tkprof to analyze it ?

xiongye,

If that wasn't the answer (from TGM) you were looking for, then maybe you need to ask another question?

live free or die
harry
Live Free or Die