Re: OCI Query hangs after approx 30min, but not at 28min

On Feb 27, 6:29 pm, "Anurag Varma" <avora..._at_gmail.com> wrote:
> On Feb 27, 6:35 pm, dale5..._at_gmail.com wrote:
>
>
>
>
>
> > Hi,
>
> > We have been tracking down this issue for a few weeks now and recently
> > recreated it outside of our application using only sqlplus. To
> > reproduce the problem we run the following script from sqlplus on a
> > Win2003 client against a 10g Oracle 64bit Server.
>
> > The sqlplus command never returns and appears to be simply waiting for
> > a response. An OCI trace gives no more information either, just
> > appears to be waiting for a response. There are no errors reported on
> > the client or server.
>
> > The problem is that the results are not consistent. When run from the
> > same client against a diff DBs sometimes it works fine. Different
> > client to the same server also sometimes works. Its not that sometimes
> > it works sometimes it doesnt. For a given client/server combination we
> > do see consistent results, that is it either always hangs after 32mins
> > or always returns.
>
> > The problem has not yet been seen against a 9i Server. This is also
> > only happening at our Clients environment, we havent been able to
> > reproduce the issue in house.
>
> > Any ideas? Help!!
>
> > DECLARE
> > sleepMins NUMBER;
> > BEGIN
> > sleepMins := 32;
> > dbms_output.put_line('About to Sleep for: ' || sleepMins ||
> > 'mins');
> > FOR idx IN 1 .. sleepMins LOOP
> > dbms_output.put_line('Sleep iteration: ' || idx);
> > dbms_lock.sleep(60);
> > END LOOP;
> > dbms_output.put_line('Finished');
> > END;
> > /
>
> is database behind a firewall? If yes then you might want to check
> firewall timeout settings
>
> http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/apx...
>
> Anurag- Hide quoted text -
>
> - Show quoted text -

Thanks but I dont think this is a firewall problem based on some recent results. From the same client (running either 9i or 10g) against the same DB Server, but 2 seperate instances we get 1 test hanging and the other returning fine. To summarize

>From some Clients (9i or 10g) to DBServer Host running 10g instance:
Hangs consistently
>From same Clients (9i or 10g) to same DBServer Host running another 9i
instance: Returns consistently

Could this be a Windows client problem, from the limited data it seems to be Win200x clients that have the problem. WinXP seems to work fine all the time.

thanks again Received on Wed Feb 28 2007 - 11:07:14 CST