Re: Process and sessions overhead

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Wed, 9 Mar 2011 10:40:39 -0500

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

Other related posts: