Re: MTS how to set up

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 28 Sep 2002 22:53:14 +1000
Message-ID: <6shl9.41757$g9.120434@newsfeeds.bigpond.com>

And in addition to what Sybrand, Kenneth and Anton have said ;)

it's actually only the User Global Area (UGA) portion of the PGA, rather than the PGA as such that lives in the SGA with MTS. Just being clear.

Although the advice to carefully adjust the large_pool_size is spot on.

Cheers

Richard
"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:an47pq$sdr$1_at_news1.xs4all.nl...
> And in addition to the answers of Sybrand an Kenneth: adjust parameters
> shared_pool_size and large_pool_size too because PGA memory moves from the
> dedicated server process to the shared pool, using large pool when it is
set
> to reduce risk of fragmentation of the shared pool.
> I think I wrote about this in the group twice, one very recent. Search
> Google if you want.
>
> Teresa <tpreto7_at_sapo.pt> schreef in berichtnieuws
> 6dabc692.0209271906.79f20e59_at_posting.google.com...
> | Hello
> |
> | I need to set up a Multi Threaded Server (MTS) for oracle 8.1.7.4 sun
> | solaris, I have looked through Oracle docus by they are not ver
> | specific, can someone please help me with this information
> |
> |
> |
> | Thanks
> | Teresa
>
Received on Sat Sep 28 2002 - 07:53:14 CDT