The leading edge of scripting languages and Oracle Database brought to you by the Data Access Development team

  • php
    October 25, 2006

Oracle Announces New Connection Pooling Feature

Christopher Jones
Senior Principal Product Manager

At the end of my Oracle Develop conference presentation today, I handed over to a key contributer to Oracle's PHP effort for this news:

Today at the "PHP/Oracle Experience: Building for Scalability" talk at Oracle Develop, Luxi Chidambaran announced a new Oracle Database 11g feature: Database Resident Connection Pooling.  This feature allows multiple middle tiers to share the same connection pool and provides improved scalability for Oracle customers. The new feature will be available through Oracle's Call Interface API (OCI).

Chidambaran also proposed changes to PHP's OCI8 extension to take advantage of Database Resident Connection Pooling.  PHP/Oracle users have had connection pooling high on their feature request list.

I have asked Luxi to write up the technical details from his presentation. Stay tuned. We are looking for input from OCI8 users about the potential changes. The current plan is to add one new php.ini parameter and make oci_close() release persistent connection resources for reuse in the pool.

We're interested in how users might configure and use the connection pool in PHP and other tools. This will directly influence the configurability vs complexity of PHP's OCI8 implementation.

Note: Oracle 11g is not yet in production.


Update: Luxi's write up is at https://blogs.oracle.com/opal/entry/highly_scalable_connection_poo

Join the discussion

Comments ( 4 )
  • Paweł Barut Wednesday, October 25, 2006
    Great News for Oracle/PHP Developers
  • Rich Friday, November 10, 2006
    sounds great! we have been needing this for 3 years. we use Oracle 9i (moving to 10g), PHP, Apache and RedHat Linux. is there any third party application that would preform the connection pooling until 11g is released? nice site! Rich
  • Bogguard Monday, April 30, 2007
    There is a 3th party opensource around called sqlrelay (sqlrelay.sourceforge.net). I haven't tried it myself though
  • Christopher Jones Monday, April 30, 2007
    I know customer who use and those who decided against SQL Relay. Any comments on it would be welcome.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.