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 |
No comments:
Post a Comment