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

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

ss

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

http://www.rampant-books.com/book_2005_2_php_oracle.htm

 

Download your Oracle scripts now:

www.oracle-script.com

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 -2016 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