Re: Location of the Sort extent pool

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 29 Apr 2003 10:15:08 +0100
Message-ID: <xorra.10891$pK2.14045@news.indigo.ie>

The SGA is a memory area. Extents are not related to memory area; they refer to storage within tablespaces.

typically in dedicated server mode (non-MTS) the memory area allocated by Oracle for a sort comes from the PGA

As for part B.. I think you've not read the concepts guide enough... "Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:1i3sav8calp9mccjbu0a1p3ngudln2a9c9_at_4ax.com...
> Where is the "sort extent pool" located? Is it in the SGA or in the
> PGA?
> I thought the SGA contains primarily the library cache and dictionary
> cache. But there is at least one optional memory area in the SGA
> according to the manual. Could this be the "sort extent pool"?
>
> Is there is an option to store data dictionary stuff in the PGA
> instead of the SGA?
>
>
Received on Tue Apr 29 2003 - 04:15:08 CDT