Query Regarding Connection string

User_42Z26

Hi,

I have defined connection string in my C# application, So database oracle side is lot of burden, since this client application is using by lot of customer,

so I have a query, How much "Connection Lifetime" should be defined in my connection string.

so our application also work effectively.

Alex Keh-Oracle

Nowadays, you shouldn't need to use Connection Lifetime anymore. There are better failover alternatives, such as Fast Connection Failover.

In terms of improving DB server performance, you should use connection pooling on the client side. Some other options include using shared server or Database Resident Connection Pooling. These options do a better job sharing connection resources on the DB side.