Managing distributed transactions within the Oracle database The Oracle database allows access to the following information on distributed transactions within the database: • Information on unresolved distributed transactions (e.g. prepared and awaiting commit/rollback) is available via the DBA_PENDING_TRANSACTIONS system view. • Information on distributed transactions awaiting recovery (e.g. “in-doubt” transactions) is available via the DBA_2PC_PENDING system view. • Information on the currently active distributed transactions is available via the V$GLOBAL_TRANSACTION system view. •Information on incoming and outgoing connections for pending transactions within an Oracle distributed transaction is available via the DBA_2PC_NEIGHBORS system view.