It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example.
First of all we need to start script on local database:
SQL>
SQL> @transactions/global.sql
Enter filters(empty for any)...
Sid :
Globalid mask :
Remote_db mask:
INST_ID SID SERIAL# USERNAME REMOTE_DB REMOTE_DBID TRANS_ID DIRECTION GLOBALID EVENT
-------- ---- ---------- -------- --------- ----------- ---------------- ----------- -------------------------------------------------- ---------------------------
1 275 4469 XTENDER BAIKAL 1742630060 8.20.7119 FROM REMOTE 4241494B414C2E63616336656437362E382E32302E37313139 SQL*Net message from client
Then we need to copy GLOBALID of interested session and run script on database that shown in column REMOTE_DBID, but with specifieng GLOBALID:
SQL>
SQL> conn sys/syspass@baikal as sysdba
Connected.
======================================================================
======= Connected to SYS@BAIKAL(baikal)(BAIKAL)
======= SID 203
======= SERIAL# 38399
======= SPID 6536
======= DB_VERSION 11.2.0.4.0
======================================================================
SQL> @transactions/global.sql
Enter filters(empty for any)...
Sid :
Globalid mask : 4241494B414C2E63616336656437362E382E32302E37313139
Remote_db mask:
INST_ID SID SERIAL# USERNAME REMOTE_DB REMOTE_DBID TRANS_ID DIRECTION GLOBALID STATE
------- ----- ---------- --------- ---------- ----------- ---------- ----------- -------------------------------------------------- --------------------------
1 9 39637 XTENDER BAIKAL 1742630060 8.20.7119 TO REMOTE 4241494B414C2E63616336656437362E382E32302E37313139 [ORACLE COORDINATED]ACTIVE
It’s quite simple and fast.