Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_2PC_NEIGHBORS

information about incoming and outgoing connections for pending transactions

Columns
   ___________________________
 
   LOCAL_TRAN_ID
      --
   IN_OUT
      "in" for incoming connections,"out" for outgoing
   DATABASE
      in: client database name; out: outgoing db link
   DBUSER_OWNER
      in: name of local user; out: owner of db link
   INTERFACE
      "C" for request commit,else "N" for prepare or request readonly commit
   DBID
      the database id at the other end of the connection
   SESS#
      session number at this database of the connection 
   BRANCH
      transaction branch ID at this database of the connection

Related:



Simon Sheppard
SS64.com