Re: sqlplus problem

[Quoted] It sounds like we need some clarification here. There are two possible scenarios when running sqlplus as a client app on a workstation that does not have a database itself but accesses a remote database via sqlnet.

1. The server is using mts.
2. The server is not using mts.

The first question becomes whether or not the SORT_AREA_SIZE set in initxxx.ora is the controlling factor for sorts in both cases or only if mts is not used. [Quoted] The second question is whether sorting is always done on server-side or whether sorting is done server-side without mts and client-side for mts: The third [Quoted] question is if sorting is done client-side then where is the sort area allocated and how can its size be controlled.

Ken

Jurij Modic wrote:

> On Tue, 6 Jul 1999 18:30:24 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> >If you don't use the Multithreaded Server, your sort_area_size is allocated
> >on the client.
>
> Sybrand,
> Maybe the above sentence is just not put into the right words, but
> AFAIK sort_area_size in a non-MTS configuration is allocated in the
> PGA area, which is a user's process memory portion *on the server*
> where instance runs.
> In any case, all instance's memory segments (SGA, PGAs, ...) are
> always allocated on the server box, none of them can be allocated on a
> client's machine, no matter if MTS is used or not.
> That said, I can't find any logical explanation for Kenneth's problem.
> I would check if all three rpt1.sql scripts are identical and if both
> svr1 aliases are pointing to the same database.
Received on Wed Jul 07 1999 - 15:17:01 CEST