I created a patch for http://bugs.php.net/bug.php?id=29779 (which can be 
considered as a feature request more than a bug).

Rather than pinging existing connection each time, which would slow down things 
too much for high traffic sites, the patch pings connections only every x 
seconds. Considering this problem occurs when a firewall drops idle connections 
after let's say one hour of inactivity, I think this is a fine solution.

I added a php.ini variable : oci8.ping_freq (if not set, oci8 works like 
before). The code adds a last_ping timestamp to the server struct, and pings 
when ping_freq > 0 && (time(NULL) - last_ping) > ping_freq. It otherwise uses 
the commented oci_ping call.

The patch (against CVS/5.0 branch) can be found at :
http://www.jeuxdecartes.net/static/oci8.ping_freq.patch

Hope you'll find this patch ok, and will include it in future releases of 5.0.

Jean-François Bustarret
eTF1 - http://www.tf1.fr


-------------------------------------
Le present message (y compris tous les elements attaches) est confidentiel et 
est destine a ses seuls destinataires. Si vous
l'avez recu par erreur, merci de l'indiquer a son expediteur par retour et de 
proceder a sa destruction dans vos systemes.
Toute utilisation ou diffusion non autorisee de son contenu, en totalite ou en 
partie, est strictement interdite. Les idees et
opinions presentees dans ce message sont celles de son auteur, et ne 
representent pas necessairement celles de TF1 (et/ou des
entites membres du Groupe TF1).

This message (including any attachments) is confidential and may be privileged. 
If you have received it by mistake please notify
the sender by return email and delete this message from your system. Any 
unauthorised use or dissemination of this message in
whole or in part is strictly prohibited. Any views or opinions presented are 
solely those of its author and do not necessarily
represent those of TF1 (and/or its group companies).

--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to