Re: PRESPAWN => ORA-03113: end-of-file on communication channel

nope, Enterprise on Solaris. the _real_ problem is that the box is hopelessly overloaded and it takes forever to get oracle connections. I'm just trying to make it a little less slow until the powers that be free up some funds for more hardware.

thanks though...

oddly enough, reads seem to work ok with prespawned connection handlers, but write attempts error out.

• mark

In article <35a66f23.0_at_news.cadvision.com>,   "Terry Dykstra [TeamPS]" <no_spam_tdykstra_at_cfol.ab.ca> wrote:
> 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
>
>

-----== 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 - 19:06:52 CDT