Re: optimal listener configuration for short but many connections

From: <moshmoshe_at_my-deja.com>
Date: Wed, 27 Sep 2000 23:49:47 GMT
Message-ID: <8qu12p$s2m$1@nnrp1.deja.com>

We have a similar problem running on 4 way e420 we get about 16 connections/sec. Running oracle8.. is multythreaded server only available in oracle8i? Also I understood that multythreade server is there only to manage memory more efficiently.. Is that wrong? 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.
>

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