Oracle query timeouts

  • Thread starter Thread starter skull_leader7
  • Start date Start date
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.
 
Back
Top