Re: Memory Problem

Ashish Shah 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.
> >

For SORT AREA use for temp sorting purpose. It should be allocate as PER SESSION basis. It is a part of memory allocated external to SGA. So, how much totally allocated ?? calc. it out yourself by counting user session connection who NEED to perform SORTING !

John Koo Received on Thu Jan 21 1999 - 17:39:12 CST