Earlier I use to get ORA-12570:Network Session: Unexpected packet read error while querying with below config:
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xyz.xyz89.test)(PORT=xxxxx))(CONNECT_DATA=(SID=xxxxxxx)));User Id=test;Password=test;Connection Timeout=600;Max Pool Size=150;Min Pool Size=10;
Later I updated my connection string as below which fixes ORA-12570 issue
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xyz.xyz89.test)(PORT=xxxxx))(CONNECT_DATA=(SID=xxxxxxx)));User Id=test;Password=test;Connection Timeout=600;Max Pool Size=150;Min Pool Size=10;Validate Connection=True;
But, I am facing performance issue while connecting to Oracle database(with Validate Connection=True) to pull some data using Dapper.
Can anyone please suggest why my query takes almost 2.5 hours to give the response most of the times and few times it gives response very quickly. Does it means there is no valid connection available in pool to pick?