Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Location of the Sort extent pool
On Tue, 29 Apr 2003 10:15:08 +0100, "Telemachus"
<telemachus_at_ulysseswillreturn.net> wrote:
>The SGA is a memory area. Extents are not related to memory area; they refer
>to storage within tablespaces.
>
"sort extent pool" or any other type of tablespaces or extent needs to be loaded into memory before Oracle can do anything with it. So it has to be some where in the architecture.
>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:58:47 CDT