Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy




Oracle Tips by Burleson 

Two Phase Commit

Two phase commit is the tool used for handling distributed databases.  If transaction modifies objects in more then one database, a single “two phase commit” can commit changes in both databases.  Oracle achieves this by splitting commit in two phases: first, each database involved in the transaction is sent “prepare for commit” request.  When all involved databases respond with “ready” message, a commit request is sent to every database participating in the transaction. To be able to issue such distributed commits, the tool must implement the transaction interface, embodied in so called XA library. This library is standard and defines operations utilized by TP monitors like Encina, Top End, Tuxedo or CICS. PHP5 does not implement the standard transaction interface, as web servers normally aren't utilized as TP monitors.

Web applications are expected to have certain look and feel.  These applications are expected to have rapid response and to deal primarily with the interactive data, entered by the end user himself.  Web applications are not batch applications designed to perform large calculations or manipulate extremely large quantities of data.  Oracle features designed to speed up large batch applications were left out of the implementation at this point. This is not to say that these features will not be added in some future implementation, as both World Wide Web and Oracle RDBMS are undergoing daily changes and development.

Zend Corp. has developed, in partnership with Oracle Corp. the product called Zend Core for Oracle which simplifies the installation and fixes many of the bugs which one can come across in an open source version. Zend Core for Oracle is pre-built version of PHP5 with a GUI installer which makes it possible to pick and choose the desired modules, without tedious and complex software rebuilding effort.  Initial reactions to Zend Core for Oracle are more then enthusiastic. By all means, it’s a wonderful product. Future for PHP and Oracle looks very bright.

See code depot for complete scripts

The above book excerpt is from:

Easy Oracle PHP

Create Dynamic Web Pages with Oracle Data

ISBN 0-9761573-0-6   

Mladen Gogala


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks

Hit Counter