Long running query - timeout issue

[hsshah]

Hi there,

I am trying to run a query to get it's result set. It takes around an hour for it to run. Before it returns with a result, my session in pl/sql developer times out. I already have "Check connection" selected in preferences. I am using Version 6.0.5.931 (MBCS)

I do not have an option to change any parameters on DB server. Do I have any options?

Thanks

hsshah

 

[Marco Kalter]

How exactly does it time out? Are there any error messages?

 

[hsshah]

When I tried to 'break' (Shift+Esc) the query (as I started to doubt if the session is still connected), it said 'ORA-03114:not connected to ORACLE'.
I worked around the problem for now, by creating a shell script on the DB server (Solaris) that outputs the resultset to a text file and running it in the background.
I am wondering if there is a way in pl/sql developer to handle such long running queries.

Thanks

 

[gulhaugen]

Reading this, I have get a feeling this is a firewall or proxy problem. Something in the middle that closes connection beeing open too long.

 

[hsshah]

Yeah. Even I think that it is a firewall issue. But my confusion is, shouldn't "Check connection selection" in preferences take care of this i.e. while the client session is waiting for the query to return, shouldn't it be sending something like 'Keep Alive' signals to the server?

- hsshah

 

[Marco Kalter]

Can you check if there is a user dump trace file on the database server that corresponds to this ORA-03114 error? Maybe it is simply a server issue.