RE: Query problem

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Fri, 08 Dec 2000 15:18:04 -0800
Message-Id: <10704.124122@fatcity.com>

How did you get the timing information? Is it from set timing on? This includes network and client processing times. Try setting sql_trace on in the session and tkprof'ing the trace file to see the actual server processing times for the statements. Also, the comparisons need to be run more than once to ensure they are consistent.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Sukumar Kurup [mailto:sukuora_at_yahoo.com] Sent: Friday, December 08, 2000 2:16 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Query problem

Yes, The results are same .

Without rtrim, the query takes 00:03:12.93 with rtrim the query takes 00:00:00.83

I am not clear as to how addition of rtrim can make such a big difference. We have also opened a tar with oracle. and they have been working on this for the last
4 days. Received on Fri Dec 08 2000 - 17:18:04 CST