This content has been marked as final. Show 1 reply
I dont see anything wrong with the connect string, and it's going to be difficult to make any suggestions with the limited information provided.
How long is "ages" exactly (or approximately :))?
What specifically is taking so long? con.open? dataadapter.fill? dataadapter.update? reader.read? etc.
If the long operation is a select query, how many rows/columns of what datatype does it return? Have you looked into the explain plan and such on the database to make sure the query is being processed efficiently?
You may want to look into adjusting ODP FetchSize to see if that helps with performance.
Also, for future reference, unless you're actually using .NET stored procedures you'd probably want to post this type of question in the [ODP.NET forum|http://forums.oracle.com/forums/forum.jspa?forumID=146].