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.
• 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.
Yorumlar
Yorum Gönder