According to the ORACLE documentation, the Connection Lifetime attribute is checked when the connection is closed and released back to the connection pool, if the connection was open for longer than the Lifetime setting then it is cleared from the pool.
My question is, does the counter for the Connection Lifetime reset after it's released back to the pool?
For example:
Connection A is in the pool and has a Lifetime of 60 seconds. Application opens a connection getting connection A from the pool. Application uses Connection A for 40 seconds and then closes and returns it to the pool. At this point it passes the Connection Lifetime check. 10 mins later the Application tries to open Connection A from the connection pool again.
Is Connection A still usable at this point?