Re: optimal listener configuration for short but many connections

We have a similar scenario
Oracle8 on 4 processor e420r
and get about 16 connections/second
my understanding for a multythreaded server is that it's not for performance reasons but to minimize memory usage..
Also, is it only available in 8i?
In article <8qo7so$722$1_at_nnrp1.deja.com>,   sybrandb_at_my-deja.com wrote:
> In article <39CF9813.FAF514EB_at_snet.net>,
> Richard Chen <qchen_at_snet.net> wrote:
> > I would like to know if anyone can offer some
 advice about how to
> > configure
> > listeners to deal with many but short lived
 connection requests such
 as
> > coming
> > from web cgi programs. We found that a
 oracle7 running on a 2Gb sun
> > ultra-4
> > can only doll out 5-6 connections per second.
 That is way too small.
 We
> > would
> > like to make it to give out at least 50
 connections per second. Is
 this
> > feasible?
> >
> > Thanks for any info.
> >
> > Richard
> >
> >
>
> This looks like the typical scenario for using
 the multi-threaded
> server.
> As Oracle 7 will be desupported very soon and
 Oracle 8i comes with a
> connection manager taking care of the scenario
 you describe, I
> recommend you upgrade.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 18:47:15 CDT