Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Max connections, sessions and Rule of thumb

Max connections, sessions and Rule of thumb

From: Yogesh <ytalreja_at_comcast.net>
Date: 13 Dec 2004 16:12:54 -0800
Message-ID: <1102983174.320326.208210@z14g2000cwz.googlegroups.com>


Gerry Sinkiewicz wrote:
> "Y" <ytalreja_at_comcast.net> wrote in message
> news:8b80bedf.0411031403.6f8cfdc4_at_posting.google.com...
> > Folks,
> >
> > We are running 6 instances of a proprietary application server
> > against an Oracle8 instance with a connection pool of 16 each (for
a
> > total of 96 connections). This is running on a dual proc Sun server
> > with 1 GB of memory As our volumes have ramped up, we need to
increase
> > the number of connections in the pool and the related parameters in
> > Oracle's config files. All users to the database go through these
App
> > Servers/connection pools.
> >
> > I believe I would need to increase the queuesize in
listener.ora
> > file and the SESSIONS/PROCESSES parameters in init.ora file. Are
there
> > any other parameters I need to change?
> >
> > I would like to know if there is a formula to determine a
"safe"
> > limit for bumping these up; i.e. if there is a rule of thumb for
> > correlating maximum number of these parameters with the # of CPUs/
> > memory size. I do realize that if I bump these up too high, I will
run
> > into the Unix limit of max. # of processes, but that typically
exceeds
> > 1024.
> >
>
> You done't really need to change queuesize unless the connection
activity is
> very busy
> (like above 5/sec on Solaris).
>
> If you have an Oracle CPU license, you can increase the processes
parameter
> inside
> your init.ora so that it is high enough, figuring 1-5MB per session.
Thank you, this is what I was looking for.

Yogesh Received on Mon Dec 13 2004 - 18:12:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US