Re: Global transactions

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> написал:

> 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