Re: sort area size

Hi All,

The URL for that is ...
  http://www.ixora.com.au/newsletter/2000_11.htm#sort_area

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: "Yong Huang" <yhuang_at_indigopool.com>

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 Tue Feb 13 2001 - 04:01:46 CST