Clever Geek Handbook

Connecting to Oracle from ASP.NET is very slow - how to diagnose?

I have an ASP.NET application that connects to an oracle database. In the meantime, there is no need to worry about it.

The performance of some queries in dev is very slow - on the order of 90 seconds to connect to the database, run the query (in fact, call SP in a batch) and return one row of results.

I run an application profiler and about 100% of the time is spent in native code, Oracle.DataAccess.Client.OpsDac.Read (in OraOps10.dll)

The same request works fine in prod. TNSPING dev db is less than 10ms and I actually have no problem connecting via sqldeveloper.

How can I determine what is causing the slowdown?

0


source to share


1 answer


Are the DEV web server and DB on the same machine? Is this your local machine?

If not, is the response time similar to your local machine?



Can you point the DEV web app to PROD? If so, is the time the same?

Is this one request or all requests?

+1


source






More articles:


All Articles