Bug #36634 [Com]: oci8.persistent_timeout not functioning

Edit report at https://bugs.php.net/bug.php?id=36634&edit=1 ID: 36634 Comment by: walovaton at yahoo dot com dot mx Reported by: zhang_yinshu at yahoo dot com Summary: oci8.persistent_timeout not functioning Status: Bogus Type: Bug Package: OCI8 related Operating System: Gentoo Linux PHP Version: 5.1.2 Block user comment: N Private report: N New Comment: Hello there, I just want to say that everything you need to understand this "problem" is right there in the manual. PHP can only check if a connection is idle as long as the process itself is doing something, in this case serving a request. So for this thing to work PHP needs to receive a request that does not touch the Oracle connection to have a chance to see if the connection is idle enough to close it. Like the manual suggests, it's a chicken-egg situation. Previous Comments: ------------------------------------------------------------------------ [2010-07-30 19:55:37] wertygol at gmail dot com I have the same problem, but this time is not Apache but IIS 5.1. When I use apache server the pconnect works fine but in IIS never close the idle connections on the Oracle 10G Database. ------------------------------------------------------------------------ [2006-03-17 18:49:33] zhang_yinshu at yahoo dot com First of all, I apology for anything I said inappropriate, I am very appreciate PHP OCI8 doing great job and all your effort. However, I got my mind set to this(please help correct me if you are not angre anymore), if i use persistent connection, when there's PHP finish query with database, oracle session will remain inactive unless PHP reuse same session. If I set oci9.persistent_timeout, inactive session should be closed, next PHP connection will open new session. My problem is my PHP session keep inactive in database and never got disconnect unless I stop apache. I would be more than happy if you can point out anything I compile/configure wrong. ------------------------------------------------------------------------ [2006-03-17 18:17:37] tony2001@php.net >read "Oracle for dummy" Yeah, I remember reading something like this when I was writing ext/oci8 module. Please stop reopening the report, nobody is going to help you in solving problems that do not exist. ------------------------------------------------------------------------ [2006-03-17 18:05:28] zhang_yinshu at yahoo dot com try this and see last activity is way beyond timeout. I realized I am wasting your time, so stop working on the case and read "Oracle for dummy", so someone else can help. select s.program, to_char(sysdate,'mm/dd/yy hh24:mi:ss') now, to_char(sysdate - (s.last_call_et)/86400,'mm/dd/yy hh24:mi:ss') last_act_dt from v$process p, v$session s where s.username is not null and s.program like 'httpd%' and s.paddr = p.addr order by s.logon_time / ------------------------------------------------------------------------ [2006-03-17 15:48:08] tony2001@php.net SQL> select user from v$session; ........ 16 rows selected. 10 seconds later: SQL> select user from v$session; ........ 9 rows selected. Please next time do it yourself and don't waste my time. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=36634 -- Edit this bug report at https://bugs.php.net/bug.php?id=36634&edit=1