Re: tkprof sorting not working when using trcsess

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: tim@xxxxxxxxx
  • Date: Fri, 2 Feb 2007 21:39:18 +0000

My simplistic test - now I'm home, but before I finally collapse from a
combination of flu and RAID5 failures, gives an output file sorted in the
order I specified (sort=exeela)  based on both sessions in the file. The
banner idea is interesting (the headers are different in a combined file of
course), but surely the whole point of trcsess is that you get one file so
no EOF?

On 2/2/07, Tim Gorman <tim@xxxxxxxxx> wrote:

TKPROF *might* be "designed" to stop when it hits EOF (obviously!) or
when it sees a banner header in a ".trc" file?  Heaven knows why, but a
simple test would be to edit out all banner headers (except the first)
from your concatenated ".trc" file and see if that helps?

Just my $0.02...


Niall Litchfield wrote:
> Not good enough! What design decision are you referring to? I can
> believe it might act that way, but trcsess making tkprof behave in an
> undocumented way smells like a bug.
>
> On 2/2/07, Egor Starostin <egorst@xxxxxxxxx> wrote:
>> > trcsess and combine multiple files, sorting is not working properly.
>> By design.
>>
>>
>> --
>> Egor
>> http://www.oracledba.ru
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
--
//www.freelists.org/webpage/oracle-l





--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: