Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25498 invoked from network); 2 Feb 2007 15:41:54 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 15:41:44 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33C305D51A6; Fri, 2 Feb 2007 16:39:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16761-04; Fri, 2 Feb 2007 16:39:36 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D65F15D5199; Fri, 2 Feb 2007 16:39:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Feb 2007 16:38:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 427375D50A9 for ; Fri, 2 Feb 2007 16:38:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16365-05 for ; Fri, 2 Feb 2007 16:38:16 -0500 (EST) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.251]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD5D65D50A3 for ; Fri, 2 Feb 2007 16:38:14 -0500 (EST) Received: by an-out-0708.google.com with SMTP id b8so636939ana for ; Fri, 02 Feb 2007 13:39:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=NPApzQDhcMyJPet92R5jnnGJcq2LTbJN60TdsxNvcwGgZT9l7TW0QOagYR310lOQQzsiw+lIz9T7gLrhg8P3HK40kT1JgEdvhX3sYNKSYRuABl7O5Q1DC7suRaFUmdx14sEjUtcwaLKGLe8ShDMBl0pzMiQKZqOjVs+FnDClMbY= Received: by 10.78.201.2 with SMTP id y2mr865391huf.1170452358708; Fri, 02 Feb 2007 13:39:18 -0800 (PST) Received: by 10.78.205.13 with HTTP; Fri, 2 Feb 2007 13:39:18 -0800 (PST) Message-ID: <7765c8970702021339l2045c5faod54885d1a9bb1b94@mail.gmail.com> Date: Fri, 2 Feb 2007 21:39:18 +0000 From: "Niall Litchfield" To: tim@evdbt.com Subject: Re: tkprof sorting not working when using trcsess Cc: oracle-l In-Reply-To: <45C38758.801@evdbt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19350_26510314.1170452358684" References: <7765c8970702021038s4e5a9636lbcf771216de45cd1@mail.gmail.com> <45C38758.801@evdbt.com> X-archive-position: 45100 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-to: niall.litchfield@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_19350_26510314.1170452358684 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 ------=_Part_19350_26510314.1170452358684 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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@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@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 ------=_Part_19350_26510314.1170452358684-- -- http://www.freelists.org/webpage/oracle-l