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:

DBA_2PC_PENDING
DBA_PROXIES
DBA_DB_LINKS
DBA_PENDING_TRANSACTIONS


© Copyright SS64.com 1999-2014
Some rights reserved