Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 138 of 521


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  


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback