Hi @"Alex Keh - Product Manager-Oracle"
In document Says Connection
Lifetime A
ttribute:
When the application closes a connection, the connection pooling service determines whether or not the connection lifetime has exceeded the value of the Connection
Lifetime
attribute. If so, the connection pooling service closes the connection; otherwise, the connection goes back to the connection pool. The connection pooling service enforces the Connection
Lifetime
only when a connection is going back to the connection pool.
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;Connection lifeTime=600;Max Pool Size=100;Min Pool Size=1;"
OracleConnection oraConn = new OracleConnection(connStr);
try
{
oraConn.Open();
}
finally
{
if (oraConn != null)
{
oraConn.Close();
oraConn.Dispose();
}
}
}
static void Main()
{
TestPerformance();
Thread.Sleep(6000);//Sleep six seconds
TestPerformance();//Current liftTime enquels four seconds?
}
My question is the same program and connection string, will reset the connection lifetime Attribute when second connection is opened?