DBA_2PC_NEIGHBORS view tips

Oracle Tips by Burleson Consulting

DBA_2PC_NEIGHBORS

<< Return to the index

Oracle 11g makes the following comments about the DBA_2PC_NEIGHBORS table: "information about incoming and outgoing connections for pending transactions"

Related notes on DBA_2PC_NEIGHBORS:

Column description of the DBA_2PC_NEIGHBORS view:

LOCAL_TRAN_ID

No comments exist for the LOCAL_TRAN_ID column of the DBA_2PC_NEIGHBORS table.

IN_OUT

Description of DBA_2PC_NEIGHBORS.IN_OUT: ""in" for incoming connections, "out" for outgoing"

DATABASE

Description of DBA_2PC_NEIGHBORS.DATABASE: "in: client database name; out: outgoing db link"

DBUSER_OWNER

Description of DBA_2PC_NEIGHBORS.DBUSER_OWNER: "in: name of local user; out: owner of db link"

INTERFACE

Description of DBA_2PC_NEIGHBORS.INTERFACE: ""C" for request commit, else "N" for prepare or request readonly commit"

DBID

Description of DBA_2PC_NEIGHBORS.DBID: "the database id at the other end of the connection"

SESS#

Description of DBA_2PC_NEIGHBORS.SESS#: "session number at this database of the connection"

BRANCH

Description of DBA_2PC_NEIGHBORS.BRANCH: "transaction branch ID at this database of the connection"

DBA_2PC_NEIGHBORS View Source

Oracle 11g's data dictionary defines the DBA_2PC_NEIGHBORS view using the following source query:

select local_tran_id, 'in', parent_db, db_user, interface, parent_dbid,
session_id, rawtohex(branch_id)
from sys.ps1$
union all
select local_tran_id, 'out', dblink, owner_name, interface, dbid,
session_id, to_char(sub_session_id)
from sys.pss1$

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books