Of those 400 connections 20 of them are active at one time. And 18 of
those oracle's own connections. So really only 2 connections are
active at one time.
EscVector wrote:
> jeffchirco_at_gmail.com wrote:
> > Dedicated server and we have about 400 connections to the database.
> >
> >
> > Valentin Minzatu wrote:
> > > Are you talking about the Oracle's installation document as
> > > recommendation?
> > >
> > > What is the number of connections made to your database? Are you using
> > > dedicated server or MTS?
>
> That's a lot of connections. I'd pool on the app side. Stay away from
> MTS if possible. Can have Queue issues for long running queries. If
> you've set sga limits, they won't increase. Cursors can use ad-hoc
> memory. PGA uses memory but releases when done. Try reading this:
> Oracle Database 10g Automated SGA Memory Tuning
> Doc ID: Note:257643.1
>
> Are you having a performance issue? You are not swapping. Is the
> system slow. Are end users complaining? If not, start reading so that
> when they do, you'll be ready.
Received on Fri Jan 12 2007 - 14:25:16 CST
