Databases
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