Re: Memory Problem

SORT_AREA_SIZE is the amount of memory that is allocated to each Connected User. SORT_AREA_RETAINED_SIZE (sp?) defaults to the SORT_AREA_SIZE setting. I'm not sure why you would want to adjust that Retained parameter.

This is how the SORT_AREA_SIZE setting works. If you set it to 10MB, then EACH user is allocated 10MB to use for sorting. If a user needs more than 10MB to do a sort, then Oracle will perform the sort on the User's default Temporary tablespace.

One last thing you should know, The sort_area_size parameter is part of the PGA, not the SGA.

Good Luck,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <36A63BDE.912FD6E5_at_lcbo.com>,   Ashish Shah <shaha_at_lcbo.com> wrote:
> > I have a q for you.. It has to do with the memory.
> >
> >We have allocated 10M of sort area size. and 1 M
> retained.
> >so now the question is if the users start using the
> short area
> >size would they share the 10M of total sort area size.
> or each
> >user connection will get seprate memory allocated. That
> means
> >if the sga is 100M and you have 50 users connected and
> doing
> >sorting then you need 100M + 500M(sort area) memory. ???
>
> >
> >do you understand what I am saying.. I just want to
> understand
> >how the memory is allocated for each user, except the
> main SGA.
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 18:44:28 CST