Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle has fixed the locking of unrelated data for pending XA transactions
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