Re: Process and sessions overhead

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Wed, 9 Mar 2011 10:40:39 -0500
Message-ID: <AANLkTinLKofgQJW4YeeUD0O9u6OS21PfnBKbiShyWbV8_at_mail.gmail.com>

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_at_gcrta.org>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_at_att.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 09 2011 - 09:40:39 CST