Re: dedicated to mts

From: prunoki <hegyvari_at_ardents.hu>
Date: Tue, 18 Sep 2007 07:24:37 -0700
Message-ID: <1190125477.750832.313880@o80g2000hse.googlegroups.com>

On szept. 18, 16:19, prunoki <hegyv..._at_ardents.hu> wrote:
> Hello,
>
> An application uses package variables and the server is in dedicated
> server mode. What is going to happen to the package variables if I
> switch from dedicated to mts? Nothing? My intuition says that I would
> not be able to use package variables anymore but I could easily be
> wrong. If I can, where does Oracle store the variables?
>
> Regards,
>
> Krisztian

Sorry, guess the solution is that when using mts the session data will be stored in the uga, so package variables will work, all the shared servers would be able to look up the values there.

Krisztian Received on Tue Sep 18 2007 - 09:24:37 CDT