Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Location of the Sort extent pool

Re: Location of the Sort extent pool

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 29 Apr 2003 21:06:43 +0100
Message-ID: <3eaedb2d$0$29713$cc9e4d1f@news.dial.pipex.com>


Yes, On my understanding if it exists it will be in the SGA - it is unclear from the article wether it exists at all if one is so foolish as to designate a permanent tablespace for disk sorts etc

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
news:m6htavg2dp6ea5h59e9muo2vjeng3qiomp_at_4ax.com...

> On Tue, 29 Apr 2003 11:19:37 +0100, "Niall Litchfield"
> <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >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.
>
> So what it is saying is that the "SORT EXTENT POOL" is indeed in the
> SGA
>
>
Received on Tue Apr 29 2003 - 15:06:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US