ID: 36634
User updated by: zhang_yinshu at yahoo dot com
Reported By: zhang_yinshu at yahoo dot com
Status: Bogus
Bug Type: OCI8 related
Operating System: Gentoo Linux
PHP Version: 5.1.2
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2006-03-17 18:17:37] [EMAIL PROTECTED]
>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] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[2006-03-17 10:00:36] [EMAIL PROTECTED]
1) Set oci8.persistent_timeout to 10 seconds.
2) Restart Apache.
3) Open several persistent connections and check if they are present in
v$process.
4) Wait for 10 seconds.
5) Run _empty_ PHP script with just <?php ?> several times.
6) Check v$process.
7) Voila - connections are not there anymore!
No bug -> bogus.
------------------------------------------------------------------------
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/36634
--
Edit this bug report at http://bugs.php.net/?id=36634&edit=1
