I thought it is based on PGA area that each session takes the initial space in the database. On Tue, Mar 8, 2011 at 11:59 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote: > I believe each connection uses around 2-3 M. > > Jeffrey Beckstrom > Database Administrator > Greater Cleveland Regional Transit Authority > 1240 W. 6th Street > Cleveland, Ohio 44113 > > >>> "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx> 3/8/11 11:48 AM >>> > > What is the memory overhead of increasing processes and sessions ? Say I > current have 1000 sessions and I want to increase that to 2000 sessions: how > much extra memory would I use assuming no additional processes sessions are > really used ? > > > > I used to recall in Oracle 7/8 days that it was a trivial amount- like 8 > bytes, or 80 bytes, or something small. But I am not sure I am remembering > correctly…. > -- Cheers, ------------------------ Chirag Majmundar