Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle has fixed the locking of unrelated data for pending XA transactions

Oracle has fixed the locking of unrelated data for pending XA transactions

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Mon, 07 Nov 2005 11:12:47 -0800
Message-ID: <436fa6b8@news.beasys.com>


Good news for any who may have suffered hanging applications because of Oracle's locking of logically unrelated data along with the relevant data for any pending prepared XA transaction. Oracle has removed the block-level locking:

https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=3566945.8

There is a patch available for
9.2.0.6 (Server Patch Set)
10.1.0.3 (Server Patch Set)
10.2.0.1 (Base Release)

For any Oracle RAC customers using WebLogic and XA transactions, the appropriate DBMS patch for this 'enhancement' is recommended.

Joe Weinstein at BEA Received on Mon Nov 07 2005 - 13:12:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US