Re: sqlplus problem

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. 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 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 - 08:17:01 CDT