Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_2PC_NEIGHBORS

information about incoming and outgoing connections for pending transactions

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com