DBA_2PC_NEIGHBORS

DBA_2PC_NEIGHBORS describes incoming and outgoing connections for pending transactions.

Column Datatype NULL Description
LOCAL_TRAN_ID VARCHAR2(22)   Local identifier of a transaction
IN_OUT VARCHAR2(3)   IN for incoming connections, OUT for outgoing
DATABASE VARCHAR2(128)   IN for client database name, OUT for outgoing database link
DBUSER_OWNER VARCHAR2(30)   IN for name of local user, OUT for owner of database link
INTERFACE VARCHAR2(1)   C for request commit, otherwise N for prepare or request read only commit
DBID VARCHAR2(16)   Database ID at the other end of the connection
SESS# NUMBER(38)   Session number of the connection at this database
BRANCH VARCHAR2(128)   Transaction branch ID of the connection at this database