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

Home -> Community -> Usenet -> c.d.o.server -> Memory Problem

Memory Problem

From: Ashish Shah <shaha_at_lcbo.com>
Date: Wed, 20 Jan 1999 15:26:06 -0500
Message-ID: <36A63BDE.912FD6E5@lcbo.com>

> 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

Original text of this message

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