Edit report at http://bugs.php.net/bug.php?id=36634&edit=1
ID: 36634 Comment by: wertygol at gmail dot com 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 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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] tony2...@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] tony2...@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. ------------------------------------------------------------------------ [2006-03-17 15:11:44] zhang_yinshu at yahoo dot com v$process only show active sessions, use v$session please, and run your test again. ------------------------------------------------------------------------ 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 http://bugs.php.net/bug.php?id=36634 -- Edit this bug report at http://bugs.php.net/bug.php?id=36634&edit=1