VIEW: SYS.DBA_2PC_NEIGHBORS

Source

View Text - Preformatted

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$

View Text - HTML Formatted

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$