Oracle Announces New Connection Pooling Feature
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.
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 http://blogs.oracle.com/opal/2007/01/03
