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@xxxxxxxxx<mailto:xt.and.r@xxxxxxxxx>> 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@xxxxxxxxxxx<mailto:dombrooks@xxxxxxxxxxx>> написал:
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--
//www.freelists.org/webpage/oracle-l