Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query: listener.ora and prespawn_max
In article <37FE6A7F.E50CF8E4_at_vnl.nl>, Frank van Bortel
<f.van.bortel_at_vnl.nl> writes
>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.
And it makes even less sense to me, we're only running 40 Win95 clients against and NT4 server...
>The exact error might help ;)
True... but the consoles are 8000 miles away! I'll try and get the local staff to make a note of the message when it next appears.
Andy
>
>
>--
>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
>
>
--
Andy Hardy. PGP key available on request