Re: sqlplus problem
Date: Tue, 06 Jul 1999 21:41:42 GMT
Message-ID: <378b73a6.6048964_at_news.siol.net>
[Quoted] 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.
>Hth,
>
>Sybrand Bakker, Oracle DBA
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)
The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jul 06 1999 - 23:41:42 CEST