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.)
--Giuse
(I think this can be quickly closed)
Previous Comments:
---------------------------------------------------------------------------
[2001-06-22 05:50:10] [EMAIL PROTECTED]
<?php
$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 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - 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?
--Giuse
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=11614
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
