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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle.ManagedDataAccess.Core 2.18.3 Slow to open first connection

39ffaabb-586b-487a-86c1-2c61a8d847d4Feb 28 2019 — edited Mar 1 2019

Hi,


Im seeing a very slow response on Connection.Open() in .NET code on windows and in docker.  Both take approx 8 seconds to open a conneciton for the first time.  Subsequent attempts (made without restarting the app) take only 5ms or so.


Has anyone else experienced this or can give any advice?

Ive tried to recreate using the old standard .net oracle lib and connection open was very fast

//ConnectionString == "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1532))(CONNECT_DATA=(SID=xxx)));User ID=xxxx;Password=xxxx;"

OracleConnection _connectionObject = new OracleConnection(this.ConnectionString);

_connectionObject.Open()

Any help greatly appreciated!

Comments

Post Details

Added on Feb 28 2019
1 comment
857 views