Show All XA Transaction Of Oracle Database

select * from DBA_PENDING_TRANSACTIONS

select * from DBA_2PC_PENDING

select * from DBA_2PC_NEIGHBORS

select * from V$GLOBAL_TRANSACTIONS

For example, you could use the following SQL statement to obtain more information about in-doubt transactions generated by Oracle XA applications.

SELECT * FROM Dba_2pc_pending p, Dba_2pc_neighbors n
WHERE p.Local_tran_id = n.Local_tran_id
AND
n.Dbid = 'xa_orcl';