Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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 readonly 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