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

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/apxtblsh.htm#CHDBBDDA

Anurag Received on Tue Feb 27 2007 - 19:29:01 CST