Oracle ODP.net Managed vs Unmanaged Driver

oracle odp.net
John Fedak picture John Fedak · Jul 11, 2013 · Viewed 42.1k times · Source

Are there any performance benchmarks between the managed and unmanaged Oracle ODP.Net drivers?

(i.e. is there any advantage to moving to the managed driver other than for architectural/deployment simplicity)

Answer

gustavodidomenico picture gustavodidomenico · Jun 30, 2014

I would like to share some results. I think that the small lack of performance is worth compared to the easiness of deployment.

enter image description here

Note: seg means seconds. Sorry about that.

Of course that it is a simple test, and there are several topics that is not covered like connection pool, stability, reliability and so on...

It is important to mention, that the scenarios were executed 100 times. So the time quantities are the average of that 100 executions.

Related questions

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle …

Read More
ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, …

Read More
Can you use Microsoft Entity Framework with Oracle?

Is it possible to use Microsoft Entity Framework with Oracle database?

Read More