Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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 Go to next page
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)

The database ID at the other end of the connection

SESS#

NUMBER

Session number of the connection at this database

BRANCH

VARCHAR2(128)

Transaction branch ID of the connection at this database