Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Memory Problem
> 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.
>
Received on Wed Jan 20 1999 - 14:26:06 CST