Re: optimal listener configuration for short but many connections

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.