Re: What's Prespawned Shadows in SQL*Net V2?

Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK> wrote in article <5oa23q$80q$1_at_power42t.hkbu.edu.hk>...
> -----BEGIN PGP SIGNED MESSAGE-----
>
> Hi, in SQL*Net V2, there's an option "Prespawned Shadows".
> What's it?
>
> - --
> PGP PUBLIC KEY: https://www.comp.hkbu.edu.hk/~wschow/pgp.html
> Key fingerprint = 15 C4 36 D6 EC CF 1D A4 7F D8 F9 EF 2E D7 32 A6
>
> -----BEGIN PGP SIGNATURE-----
> Version: 2.6.3i
> Charset: noconv
>
> iQCVAwUBM6iM9L3ixeOqBhAdAQHpDQP/RkOvQ8Zy/koq7FuQlyEGkaG8Z2rJEKHB
> BJdk8lEt4/C7dM1ijcz+1HHwfCMGcIvMPPjojArh36aKbx/xBy4OGWgP+eRE1hN0
> ZWJ4sp6jbZoztCdgW63QWQ/pdyof93tl11wcxPWVo2VXRlhqYdbjCMT5I/QwVAAc
> zZRFMioG39o=
> =aRsM
> -----END PGP SIGNATURE-----
>

It controls the number of 'spare' processes the listener maintains to accept connection requests. Basically, the listener spawns these spare processes, which then wait aroung until needed. This can speed connection time, since otherwise the listener has to spawn a new process for each request.

Its not needed for all platforms; I dont think it helps much with NT, for instance.

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.