ID: 36634
User updated by: zhang_yinshu at yahoo dot com
Reported By: zhang_yinshu at yahoo dot com
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Gentoo Linux
PHP Version: 5.1.2
New Comment:
by query v$session view from Oracle database
Previous Comments:
------------------------------------------------------------------------
[2006-03-06 21:06:23] tony2001@php.net
How do you determine if they are "inactive" or not?
------------------------------------------------------------------------
[2006-03-06 21:02:20] zhang_yinshu at yahoo dot com
[did] specify below statements in php.ini
oci8.max_persistent = 20
oci8.persistent_timeout = 60
oci8.ping_interval = -1
info() confirm with
oci8
OCI8 Support enabled
Revision $Revision: 1.269.2.8 $
Active Persistent Connections 0
Active Connections 0
Oracle Version 9.2
Compile-time ORACLE_HOME /oracle/product/9.2.0
Libraries Used no value
Temporary Lob support enabled
Collections support enabled
oci8.default_prefetch 10 10
oci8.max_persistent 20 20
oci8.old_oci_close_semantics 0 0
oci8.persistent_timeout 60 60
oci8.ping_interval -1 -1
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20
[want]: oracle session opened by oci_pconnection be closed after
inactive for 60sec.
[see]: oracle session persist.
------------------------------------------------------------------------
[2006-03-06 20:22:15] tony2001@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2006-03-06 20:12:44] zhang_yinshu at yahoo dot com
Description:
------------
oci8.persistent_timeout not functioning does not close connection after
specified period expired. even with oci8.ping_interval disabled
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36634&edit=1