Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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  


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index