Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Managed ODP.NET Connection Open Performance

EasonLiuApr 14 2016 — edited Apr 25 2016

Hi everyone

    When I test the latest version of the ODP components(Oracle.ManagedDataAccess.Dll Version:12.1.0.2.160119) and found a Performance problem


use Test code e.g:

void TestPerformance()

{

      string connStr = @"Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =IP)(PORT =1521)))

(CONNECT_DATA =(SERVICE_NAME = *)));user id=*;password=*;Pooling =true;Max Pool Size=100;Min Pool Size=1;"

       OracleConnection oraConn = new OracleConnection(connStr);

       try

       {

           System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();

           watch.Start();

           oraConn.Open();

           watch.Stop();

           SetInfo("Spend Time" + watch.ElapsedMilliseconds + "ms");

       }

       finally

       {

          if (oraConn != null)

          {

             oraConn.Close();

             oraConn.Dispose();@

          }

        }

}

With the use of the ODP.DLL(Oracle.DataAccess.Dll Version:2.111.7.0) contrast test results

ODP VersionFirstSecondThird
ManagedDataAccess682ms1ms0ms
DataAccess78ms1ms0ms

Although the time is not much, but our application can access different database during initialization, accumulated a lot of time

Look forward to your reply

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2016
Added on Apr 14 2016
8 comments
2,924 views