Re: Global transactions

Cheers Sayan ... unfortunately no x$ but I will see if there any clues in the script.

Sent from my iPhone

On 11 Jul 2017, at 16:17, Sayan Malakshinov <xt.and.r_at_gmail.com<mailto:xt.and.r_at_gmail.com>> wrote:

Hi Dominic,

I use following query, perhaps it can help you: https://github.com/xtender/xt_scripts/blob/master/transactions/global.sql

Best regards,
Sayan Malakshinov
Oracle ACE Associate, Oracle performance tuning expert http://orasql.org

11 июля 2017 г. 5:29 PM пользователь "Dominic Brooks" <dombrooks_at_hotmail.com<mailto:dombrooks_at_hotmail.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

--
http://www.freelists.org/webpage/oracle-l