Re: sort area size

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 12 Feb 2001 23:43:31 +0100
Message-ID: <t8gpkrhquhok19@beta-news.demon.nl>

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"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 ?
>

b and when the sorts exceeds sort_area_size a temporary segment on disk is created
> 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?
>

check the sort_area_retained_size parameter, which determines the memory which is retained.
Ultimately though the O/S will fault the memory out.

>
>
> Many thanks so far,
>
>
> Henk Streunding
>
>
>
Received on Mon Feb 12 2001 - 16:43:31 CST