Re: Performance issue with Oracle 8i : order by

From: David <david73_at_asef.us.es>
Date: Tue, 25 Mar 2003 18:49:46 +0100
Message-ID: <Pine.LNX.4.21.0303251841001.2002-100000@asef.us.es>

You have to take accout the network traffic and how is your network. You can test it with tnsping .
David.

On 25 Mar 2003, PPN wrote:

> Hello.
>
> I'm experiencing some strange behavior.
> Using TOAD, when I run "select count(*) from (select * from my_table
> order by 1,2);", it takes 7 seconds to answer "25000". When I telnet
> the server, use SQLPLUS and run the same request, the result is
> immediate.
> Does anyone have an explanation for this ? I tried replacing TOAD by
> SQLPLUS (the client version I've got on my Windows), and same
> behavior.
>
> Thanks.
> P.
>
Received on Tue Mar 25 2003 - 11:49:46 CST