Re: sort latch usage in MTS mode

In fact note 30815.1"Init.ora Parameter SORT_AREA_RETAINED_SIZE Reference Note" says: "If the shared server is used, allocation is to the SGA until the value in SORT_AREA_RETAINED_SIZE is reached. The difference between SORT_AREA_RETAINED_SIZE and SORT_AREA_SIZE is allocated to the PGA." It's also true that the same note says "The default value as reflected in the V$PARAMETER dynamic performance view is 0. However, if you do not explicitly set this parameter, Oracle actually uses the value of the SORT_AREA_SIZE parameter."

So by default the whole sort area is in the Large Pool; one could change this by explicitly setting SORT_AREA_RETAINED_SIZE.

It seems that 223153.1only considers the default case.

HTH
Alberto

On 8/8/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> That's interesting since I always thought that it's sort_area_retained_size what is allocated from large pool and the rest (sort_area_size - sort_area_retained_size) is allocated out of the PGA still.
>
> Time for some checks indeed.
>
>
>
> > To Alex:
> > sort will use large pool in MTS mode. Please check out metalink note 223153.1. It is very easy to reproduce/prove.

-- 
Alberto Dell'Era
"the more you know, the faster you go"
--
http://www.freelists.org/webpage/oracle-l