Home » Open Source » Programming Interfaces » Php-Oracle pooling
Php-Oracle pooling [message #77003] Wed, 26 May 2004 05:18 Go to next message
Messages: 43
Registered: August 2000

we´re interested in using connection pooling in order to control the number of connections to database.
Now we use persistent connections with the ora_plogon() and OCIPLogon() function calls. Nevertheless, persistent connections do not scale as well as connection pooling. A persistent connection will be kept open for a process, but it will not allow connections to be shared between different processes.

Is there any solution (inside PHP or not) to implement pooling connection to Oracle?

We know tools like SQL-Relay, but how well this tool integrates for applications already deployed.

How we can limit the number of connections to Oracle?

Thanks a lot in advance.

Re: Php-Oracle pooling [message #77011 is a reply to message #77003] Sun, 06 June 2004 04:52 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member

Third party tools like SQL Relay (http://sqlrelay.sourceforge.net/) can be used to enable connection pooling for Oracle and other databases.

Best regards.

Re: Php-Oracle pooling [message #359163 is a reply to message #77011] Thu, 13 November 2008 23:37 Go to previous message
Messages: 28
Registered: July 2005
Junior Member
You can use the latest OCI8 extension (1.3.4) and Oracle database 11g feature 'Database Resident Connection Pooling'. More here: http://www.oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf
Previous Topic: Performance issue using OLE DB, need alternatives
Next Topic: PhpOracleAdmin - ie PhpMyAdmin
Goto Forum:

Current Time: Sat Sep 25 08:29:46 CDT 2021