DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_2PC_NEIGHBORS

Object Details
Object Name: DBA_2PC_NEIGHBORS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

information about incoming and outgoing connections for pending transactions

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCAL_TRAN_ID VARCHAR2 (22)
IN_OUT VARCHAR2 (3)
"in" for incoming connections, "out" for outgoing
DATABASE VARCHAR2 (128)
in: client database name; out: outgoing db link
DBUSER_OWNER VARCHAR2 (128)
in: name of local user; out: owner of db link
INTERFACE VARCHAR2 (1)
"C" for request commit, else "N" for prepare or request readonly commit
DBID VARCHAR2 (16)
the database id at the other end of the connection
SESS# NUMBER

session number at this database of the connection
BRANCH VARCHAR2 (128)
transaction branch ID at this database of the connection
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOCAL_TRAN_ID
,      IN_OUT
,      DATABASE
,      DBUSER_OWNER
,      INTERFACE
,      DBID
,      SESS#
,      BRANCH
FROM SYS.DBA_2PC_NEIGHBORS;

Dependencies

[top of page]

SYS.DBA_2PC_NEIGHBORS references the following:

SchemaSYS
ViewPS1$
ViewPSS1$
SYS.DBA_2PC_NEIGHBORS is referenced by following:

SchemaPUBLIC
SynonymDBA_2PC_NEIGHBORS