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] 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.
------------------------------------------------------------------------
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
