Global transactions
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Tue, 11 Jul 2017 14:29:11 +0000
Message-ID: <DB6P190MB0454A77C7C53BAF191A51BF2A1AE0_at_DB6P190MB0454.EURP190.PROD.OUTLOOK.COM>
How to map between v$transaction and v$global_transaction?
Date: Tue, 11 Jul 2017 14:29:11 +0000
Message-ID: <DB6P190MB0454A77C7C53BAF191A51BF2A1AE0_at_DB6P190MB0454.EURP190.PROD.OUTLOOK.COM>
How to map between v$transaction and v$global_transaction?
I need to get an orphaned XA transaction rolled back. There is no session. So I plan to use DBMS_XA.
I know the XID etc from v$transaction.
DBMS_XA.XA_ROLLBACK takes a DBMS_XA_XID constructed from values in v$global_transaction.
I can't make the link to figure out which row in the latter I want.
What am i missing?
Cheers
Dominic
Sent from my iPhone--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 11 2017 - 16:29:11 CEST