ID: 11614
User Update by: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: OCI8 related
Operating system: windows 2000
PHP Version: 4.0.5
Description: ociplogon always reopens a new connection

I think I've found a really valid explanation:

Christopher Ostmo <[EMAIL PROTECTED]> told me

"the connections are actually persistent, which 
means that you will in fact benefit.  The down side is that you are not 
going to always get the same persistent connection for each request"

and finally I understood:

to be sure, I've set 
ThreadsPerChild 3
in my httpd.conf and now get a maximum of 3 persistent connections to oracle; (this is 
just an explanation for someone who thinks to have the same problem...)

this simply means you have to estimate and configure web&oracle server for the worst 
case (maximum number of conn.)


(I think this can be quickly closed)

Previous Comments:

[2001-06-22 05:50:10] [EMAIL PROTECTED]

$conn = ociplogon('user','pass','testdb');
echo "Server Version: " . OCIServerVersion($conn);

reloading the same page I get ever more connections;

you can check it with:
select * from v$session where status ='ACTIVE'  


oracle version is:
Oracle8i Enterprise Edition Release - Production
With the Partitioning option
JServer Release - Production

web server:
Apache 1.3.12, with php running as a module

the only active module in php.ini is oci8.dll;


the php manual, chapt.22 says :
When a persistent connection is requested, PHP checks if there's already an identical 
persistent connection (that remained open from earlier) - and if it exists, it uses 
it. If it does not exist, it creates the link.

is this related to apache's multithreaded behaviour on windows?



Full Bug description available at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to