Re: Sorting works incorretly on Client

I know, the sorting itself runs on the server. That's, why it is so strange: If I use the same query on the server console it runs fast, on a client slow (both with sqlplus). It looks like an network problem, but again, afaik there are no issues with our network.
I tried already setting the array size, it has no effect...

Jakob

"Richard Foote" <Richard.Foote_at_oracle.com> wrote in message news:3D4F1344.393429E1_at_oracle.com...
> Hi Jakob,
>
> Not entirely sure I understand your question in that Oracle always
> performs its sorts on the server. However, that aside note the
> following:
>
> For issue 1. Depending on the settings of NLS_LANGUAGE, Oracle uses a
> default ordering method. If you wish to change you can set the NLS_SORT
> to be any linguistic definition supported by the language setting.
>
> For issue 2. Assuming that the sort parameters are the same for both the
> client and server sessions, then the sorting overhead and times should
> be the same. Therefore it suggests that perhaps Oracle is a bit slow in
> transferring the data across to the client. Assuming the network is OK
> and you're using SQLPLUS, are you sure the array size is sufficiently
> set ?
>
> Cheers
>
> Richard
>
> Jakob Blomer wrote:
> >
> > Hi,
> > I've a problem with our Oracle 8i developer system: If I sort a table
(ca.
> > 60000 rows, indexed) on a Client mashine oracle sorts
> > 1. Wrong order
> > 2. It takes forever (about 15 seconds)
> > I found a workaround only for the first problem: alter session set
> > nls_sort=binary;
> > I tried sorting on the server mashine and everything works fine. On the
> > production system in our customer's company everything works fine on
both,
> > the client and the server.
> > I checked the Net8 configuration and couldn't find anything bad
configured.
> > The configuration is almost the same as on the server.
> > We have an 100MBit switched network, all other network operations are
ok.
> >
> > Thanks for any help or suggestions,
> > Jakob
Received on Tue Aug 06 2002 - 08:11:06 CDT