Pending Transaction Neighbors Script

COL LOCAL_TRAN_ID FORMAT A13

COL IN_OUT FORMAT A6

COL DATABASE FORMAT A25

COL DBUSER_OWNER FORMAT A15

COL INTERFACE FORMAT A3

SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, DBUSER_OWNER, INTERFACE

FROM DBA_2PC_NEIGHBORS

/

SQL> CONNECT SYS@hq.acme.com AS SYSDBA

SQL> @neighbors_script

LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER INT

————- —— ————————- ————— —

1.15.870 out SALES.ACME.COM SYS C