The availability of Oracle Database 11g Release 2 has Christopher Jones blogging about the new features useful for PHP OCI8 applications. They include enhancements that let online production applications be upgraded with minimal downtime, and features that improve existing important capabilities introduced in Oracle 11g Release 1, such as DRCP connection pooling and the Client Query Result Cache.

Jones comments that the PHP OCI8 1.2.5 and 1.3 extensions compile and run against Oracle Database 11g Release 2 without modification. PHP OCI8 1.3 is available with PHP 5.3.

Highlights from Jones' list of Oracle Database 11g Release 2 feature favorites, which he writes about in more detail in his blog, contain:

• A new Database Resident Connection Pool (DRCP) dynamic performance view V$CPOOL_CONN_INFO. There is a GV$ counterpart for Oracle RAC.

• The Oracle 11g Client Query Result Cache (CQRC), which is supported with DRCP connections.

• Table Annotations now supported for CQRC, making it easier for existing applications to get performance benefits from result caching.

• The prefetching of rows from REF CURSORs (aka Cursor Variables), also supported in Oracle Database 11gR2, greatly increases performance when Oracle PL/SQL stored procedures and functions are used to encapsulate business logic.

Jones also points out two features in the new release that benefit web applications, although there are more:

• Edition-base redefinition that make it safer and easier to do web application upgrades.

• The introduction of RAC One Node.

More Information

Oracle Database 11gR2 Enhancements for PHP - Jones' blog entry

White papers on Oracle Database 11g Release 2

Oracle Database 11g Release 2 (11.2) Documentation [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter