Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to cancatenate multiple tracefile into a large one
"Harry Sheng" <hsheng_at_innovance.com> wrote in message news:<0Bim9.14189$H67.65249_at_tor-nn1.netcom.ca>...
> Hi, Group
>
> I have 4 sql trace files taken from a connection pool of 8 connections.
> I can run tkprof against each individual trace file, but the statistics are
> separated into different output files.
> How can I cancatenate them into a large trace file? The simple unix
> shell cancatenation seems not work. It core dump the tkprof.
>
> H.S
Harry, From past metalink support postings I do not believe there is anyway to concatentate the multiple (MTS) trace files into one member for trying to tune one end-user session's activity.
Perhaps someone else will know different, but I think you are stuck with manual analysis and resolution of the statistics.
HTH -- Mark D Powell -- Received on Tue Oct 01 2002 - 13:23:07 CDT