Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

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

Static Data Dictionary Views, 115 of 452


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: client database name; OUT: outgoing database link 

DBUSER_OWNER 

VARCHAR2(30) 

 

IN: name of local user; OUT: 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-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index