RE: Process and sessions overhead
- From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
- To: <Lu.Jiang@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Mar 2011 12:17:26 -0500
OK, that is 1mb for each connected user session. What I am really
looking for is the over head of just the parameters without connected
sessions. For the version in question (11.1.0.7) I do not have a test
system available to try it. L
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jiang, Lu
Sent: Tuesday, March 08, 2011 12:10 PM
To: CRISLER, JON A (ATTCORP); oracle-l@xxxxxxxxxxxxx
Subject: RE: Process and sessions overhead
In Oracle 10g dedicated system, by default each connected user session
uses 1MB memory.
Lu
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of CRISLER, JON A
(ATTCORP)
Sent: Tuesday, March 08, 2011 11:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Process and sessions overhead
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....
Other related posts:
