Oracle query timeouts

S

skull_leader7

Hi all...

I have an ASP.NET application that is using the managed provider for
Oracle (i.e. System.Data.OracleClient). One of my pages contains a
query that takes quite a while to run, and results in a timeout error.


I would hope to be able to eventually optimize this query to alleviate
the problem, but in the meantime I'd like to increase the connection /
query timeout within .NET. Is there any way to do this with the
managed Oracle provider? If not within .NET, is there some sort of
connection timeout setting that can be changed by the DBA that might
help?

Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OracleClient, Oracle 10g, Connection failure 5
Oracle .NET provider(s) - setting connection and query timeouts ... 4
Connecting to Oracle gives error 9
Connection problem with Oracle client and pooled connections 4
System.Data.OracleClient exception while using multiple Oracle homes 2
NullReferenceException calling OracleConnection.Open() 1
ORA-03113 exception thrown 1
Problem connecting to Oracle database 3

Top