Re: Query: listener.ora and prespawn_max

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 08 Oct 1999 15:04:48 -0700
Message-ID: <37FE6A7F.E50CF8E4@vnl.nl>

Andy Hardy wrote:

> Hi,
>
> We have a group of 40 consoles/PCs that are accessing our Oracle 7.3.4
> database via Oracle Forms.
>
> Periodically, all consoles are rebooted and they all try to
> automatically connect back to Oracle. Sometimes, the connection will
> fail for some consoles with an error that seems to refer to the TNS
> listener not being available (sorry, cannot remember the exact
> message/code).
>
> Might this be alleviated by raising the prespawn_max to a higher number
> (currently set to 10) or am I looking at the wrong solution?
>
> What are the downsides to raising this value?
>
> Andy
> --
> Andy Hardy. PGP key available on request
> ===============================================================

4.2.3.4.1 PRESPAWN_MAX The maximum number of prespawned dedicated server processes the listener will create. This number must be at least as many as the sum of the pool size for each protocol. Set this value to a large number so that prespawned dedicated server processes are always available for new connections.

Don't quite understand this, I have no pre spawned servers, and up to 800 sessions, without problems.
The exact error might help ;)

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Oct 08 1999 - 17:04:48 CDT