Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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