Re: prespawned listeners

Cat10021 wrote:
>
> I have increased the prespawn number in the listener on an
> Oracle instance to 5 and set the maximum to 5 . I notice that
> that at max there are 5 listener processes running . But I notice
> no significant difference in connection time from a PC. In fact I
> have noticed that there are more connect problems with the
> increased processes .
>
> What does PRESPAWNING listener processes buy me ??

  It is suitable for the case where the startup time of processes are long.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.