Re: Shared Server intermittently hanging.

"Steven Pannell" <steven.pannell_at_gmx.net> wrote in message news:a1g15h$qgarg$1_at_ID-82797.news.dfncis.de...
> Hi,
>
> I have setup two shared servers using Oracle 8i on a Sun Solaris(7) box.
> Since then I have experienced problems whereby the servers seems to
> intermittently hang when returning results from a select statement. When
I
> execute a basic select * from x where .... clause sometimes it returns
very
> fast and other times it appears to hang for sometime before returning the
> results. There is no real logical pattern. At times it just seems to
hang
> for a while before returning the results. The statements are the same and
I
> am the only user on the database. If I switch back to dedicated servers I
> do not get this problem. Has anyone else experienced such a problem?
>
> Would appreciate your feedback,
>
> thanks in advance,
> Steve,
>
>
>

I have now increased the number of shared servers to 10 and now it seems to be better. Seems two wass too few and long statements where blocking the server. Received on Tue Jan 08 2002 - 23:53:41 CST