Re: sort_area_size

S-A-S is a coponent of the UGA (User Global Area).

The UGA is a component of the PGA (Program Global Area).

When running in dedicated server mode, the PGA (and the UGA) is entirely separate from the Shared Pool. But in MTS, the UGA cannot be part of the PGA, and must instead be shifted somewhere global. By default, the UGA (and hence the S-A-S) gets shunted into the Shared Pool. *If* a Large_pool has been configured, then the UGA gets shunted there instead.

Therefore, it is NOT true that the sort_area_size will be allocated from the large_pool if you are running Dedicated Server.

It is sort of true that the Large Pool only makes sense in MTS and when running RMAN.

If you are running RMAN or MTS without a large pool, *then* the shared pool gets used for the memory allocations.

Regards
HJR "Daud" <daud11_at_hotmail.com> wrote in message news:f0bf3cc3.0207290154.91001cb_at_posting.google.com...
> Oracle 8.1.7.3.0 on HPUX 11.0
>
> It is true that when large_pool_size is set, the sort_area_size will
> be allocated from it instead of shared_pool_size. Or is
> large_pool_size only use for MTS and RMAN.
>
> rgds
> Daud
Received on Mon Jul 29 2002 - 07:32:23 CDT