Re: sort area size

Allocated when an operation needs it. It's incrementally allocated, not allocated the whole sort_area_size at one shot. The memory is released back to PGA once the sort is done.

Read Steve Adams' November 2000 newsletter.

Yong Huang
yong321_at_yahoo.com
yhuang_at_indigopool.com

Henk Streunding <9697nl_at_bart.nl> wrote in message news:cdYh6.20501$B5.134845_at_typhoon.bart.nl...
> Hello,
>
>
> a question about the sort area size :
>
>
> Is the amount of memory allocated when a user logs in or
> is it allocated at the moment when an operation needs it ?
>
> If the second option is the right one, then another question :
> Does it keep this amount which is needed till the parameter-setting is
 reached
> or does it claim the amount set in the init.ora at once?
> Is the amount allocated released after the execution has come to an end,
 or
> does it keep the amount available for the user?
>
>
>
> Many thanks so far,
>
>
> Henk Streunding
>
>
>
Received on Mon Feb 12 2001 - 16:57:58 CST