Using Google for the phrase "SORT EXTENT POOL" gives
http://www.ixora.com.au/q+a/0101/31171404.htm as the first result, and a
very appropriate result it is too.
I'd have thought that the primary use of the SGA was to store database
blocks in the buffer pools but there you go.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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 - 05:19:37 CDT
