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

VIEW: SYS.CDB_2PC_NEIGHBORS

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

information about incoming and outgoing connections for pending transactions in all containers

[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 (30)
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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_2PC_NEIGHBORS;

Dependencies

[top of page]

SYS.CDB_2PC_NEIGHBORS does not reference any database object

SYS.CDB_2PC_NEIGHBORS is referenced by following:

SchemaPUBLIC
SynonymCDB_2PC_NEIGHBORS