If this is Workgroups on NT, you're out of luck. PRESPAWN is not supported.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
bracher_at_my-dejanews.com wrote in message
<6o3ima$tal$1_at_nnrp1.dejanews.com>...
>help...
>
>I've been tweaking my listener.ora file trying to speed up SQL*Net
>connections to a database on a hopelessly overloaded box. this
>morning I setup up a small test of the PRESPAWN options like so
>
> (PRESPAWN_MAX = 10)
> (PRESPAWN_LIST=
> (PRESPAWN_DESC=
> (PROTOCOL=TCP)
> (POOL_SIZE=5)
> (TIMEOUT=120)
> )
> )
>
>it works great, vastly improved connection times. the sad part is
>that I've started to see a lot of
>
> ORA-03113: end-of-file on communication channel
>
>errors. removing the PRESPAWN options and restarting the listener
>fixes the problem. so for now I'm back to slow connections.
>
>any idea what's happening here???
>
>- mark
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 10 1998 - 14:46:17 CDT
