Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sorting works incorretly on Client
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