DRCP Pooled Server Marked As 'Active' Even When The Connection Is Released Back To The Pool (Doc ID 1362582.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 5th Oct 2015***

Goal

After releasing a PHP session the pool, the session remains active until INACTIVITY_TIMEOUT is reached.

You can check the connection status by running;

select * from v$cpool_conn_info where CONNECTION_STATUS = 'ACTIVE';


Is that the intended behavior ?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms