Re: Anyone having troubles with shared server on VMS 10g?
Date: Fri, 18 Jan 2008 07:43:22 -0800
Message-ID: <4790c91b$1@flight>
Syltrem wrote:
> I have had multiple instances where I had to kill the dispatcher process on
> 9i to enable people to log on again.
> Sometimes, the connected sessions would still work, so I just changed
> tnsnames.ora to use dedicated sessions until the end of the day (at which
> time I could kill the dispatcher when there were no more shared sessions
> connected).
>
> After you kill the dispatcher with stop/id, it is automatically restarted
> and people can connect again.
>
I recall seeing that occasionally on 9i as well. This problem is different. What I'm seeing is that the listener never hands off the connection to a dispatcher (I can tell this by the processes that own the ports at each end of the link).
I have worked around the problem by adding another listener with its own set of dispatchers and splitting the workload between these listeners (basically I have one set of web servers that connect to listener a and another set that connect to listener b). Since doing that about a week ago I haven't seen any hangs.
> I sure hope this is less of a problem on 10g.
> I use shared connections to save on memory with sometimes a lot of
web users
> connected, never know how many thay can be.
To answer an earlier question, I'm using shared server because these web servers can generate a pretty high rate of connect requests and it takes too long to start a dedicated server on VMS. The vast majority of the connections are just grabbing fairly small bits of data and then disconnecting - so shared server is a much more efficient model. Of course as you note it also saves on memory if a number of web clients connect at the same time. Received on Fri Jan 18 2008 - 09:43:22 CST