Re: sort latch usage in MTS mode
- From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- To: afatkulin@xxxxxxxxx
- Date: Wed, 8 Aug 2007 20:05:31 +0200
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@xxxxxxxxx> 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"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
