Shared Server intermittently hanging.

From: Steven Pannell <steven.pannell_at_gmx.net>
Date: Wed, 9 Jan 2002 00:59:47 +0100
Message-ID: <a1g15h$qgarg$1@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, Received on Tue Jan 08 2002 - 17:59:47 CST