Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sort area size

Re: sort area size

From: emerald <emerald_at_net.hr>
Date: Sat, 22 Feb 2003 18:37:06 +0100
Message-ID: <b38c90$fch$1@bagan.srce.hr>


SORT_AREA_SIZE determins the maximum amount of memory that can be given to each user for performing sorts. If a sort needs more space than SORT_AREA_SIZE, TEMP tablespace is used. In your database, each user can get 65536 bytes for sorting. If you had 200 users, than they could allocate 200*65536 bytes at a time. Consider that, if you plan to increase this parameter.
SORT_AREA_RETAINED_SIZE is the memory which user holds on the server even if he is not sorting at the moment. Since it is equal to SORT_AREA_SIZE, your users always hold 65536 for sorting.
If you increase sort_area_size to, say, 512k, the situation would be like this: when user logs on, he gets 64k for sorting. When performing sort, he can allocate up to 512k for sorting operations (order by, group by). After sorting is done, he holds 64k (sort_area_retained_size), and releses the rest.

manisiva2002 <member25406_at_dbforums.com> wrote in message news:2561721.1045901390_at_dbforums.com...
>
> How is a sort area size calculated.The size 65536 given to
> sort_area_size in the init parameter and sort_area_retained_size which
> is again 65536 idicates what ?
> Can anyone explain this
> Thanks
> ManiSiva
>
> --
> Posted via http://dbforums.com
Received on Sat Feb 22 2003 - 11:37:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US