Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sort Area Size
In article <1025341278.8484.0.nnrp-14.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>I think I want to modify your answers slightly.
>I'm going to go back and repeat the tests,
>but my observations in the past have been
>that any sorting starts by allocating space
>in the UGA, and once the in-memory demand
>exceeds the sort_area_retained_size the excess
>is allocated from the PGA. Then the UGA space
>is left open after the PGA space is released so
>that the UGA can be used to pipeline the result
>set onwards.
This reflects what Oracle's online docs say. I'd be interested in your repeated test results. Received on Mon Jul 01 2002 - 07:14:29 CDT
![]() |
![]() |