check whether following link can be of any use.. say may be what if you increase no of slaves and implement parallesm for some tables http://forums.oracle.com/forums/thread.jspa?threadID=2182012&tstart=120 thanks..subodh On 8 March 2011 22:18, CRISLER, JON A (ATTCORP) <JC1706@xxxxxxx> wrote: > 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…. > -- ============================== DO NOT FORGET TO SMILE TODAY ==============================