Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sort area size
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