Re: Some memory concepts

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Mon, 9 Jun 2003 18:09:15 +0800
Message-ID: <1055153357.9939@cswreg.cos.agilent.com>

Comments Inline....

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:a4m8ev40su88t5jkrgvqc39hqh731o8sr2_at_4ax.com...
> I have some questions regardng the relationships between shared pool
> and large pool.
>
> Which one of them, shared pool or the large pool, stores the PGA?
> Under what type of settings?

The PGA is Process memory and stored in the shared Server or the Dedicated server process depending on the MTS Usage. It is Neither stored in the Shared Pool or the Large Pool.

>
> Which one of them, shared pool or the large pool, storesthe UGA?
> Under what type of settings?

If the Large Pool is Configured than the UGA is part of the Large Pool in a MTS Conf. and Part of the Shared Pool if there is No Large Pool. In a Dedicated Server Conf. the UGA is part of the PGA and hence resides in the Server Process Memory.

>
> Thanks

HTH Regards,
Ganesh R Received on Mon Jun 09 2003 - 05:09:15 CDT