DB version: 19c
OS : RHEL 7.9
I have 2 distributed transactions which runs across 2 databases.
These distributed transactions have become in-doubt transactions and hence got listed in dba_2pc_pending view.
Application guys want to know what tables are involved in these 2 transactions that are in 'in-doubt' state now.
Hence I am looking for ways to 'translate' dba_2pc_pending.LOCAL_TRAN_ID like 18.23.245864 listed below to a sid and serial# in gv$session.
SQL> SELECT RETRY_TIME, LOCAL_TRAN_ID, STATE FROM dba_2pc_pending;
RETRY_TIME LOCAL_TRAN_ID STATE
------------------- ---------------------- ----------------
09-11-2022 13:18:32 18.23.245864 prepared
09-11-2022 13:23:16 67.13.356721 prepared