Re: Shared Server intermittently hanging.

"Steven Pannell" <steven.pannell_at_gmx.net> wrote in 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,
>
>
>
>

run "truss" against the process to see upon which system call it is hanging. Received on Tue Jan 08 2002 - 19:10:47 CST