Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tkprof sorting not working when using trcsess

Re: tkprof sorting not working when using trcsess

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 2 Feb 2007 20:06:17 +0000
Message-ID: <7765c8970702021206i68ffd5abq135cc1cf16e91ed4@mail.gmail.com>


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_at_evdbt.com> 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_at_gmail.com> wrote:
> >> > trcsess and combine multiple files, sorting is not working properly.
> >> By design.
> >>
> >>
> >> --
> >> Egor
> >> http://www.oracledba.ru
> >> --
> >> http://www.freelists.org/webpage/oracle-l
> >>
> >>
> >>
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 02 2007 - 14:06:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US