DBA_2PC_PENDING

DBA_2PC_PENDING describes distributed transactions awaiting recovery.

Column Datatype NULL Description
LOCAL_TRAN_ID VARCHAR2(22) NOT NULL String of form: n.n.n; n is a number
GLOBAL_TRAN_ID VARCHAR2(169)   Globally unique transaction ID
STATE VARCHAR2(16) NOT NULL Collecting, prepared, committed, forced commit, or forced rollback
MIXED VARCHAR2(3)   YES indicates part of the transaction committed and part rolled back
ADVICE VARCHAR2(1)   C for commit, R for rollback, else NULL
TRAN_COMMENT VARCHAR2(255)   Text for commit work comment text
FAIL_TIME DATE NOT NULL Value of SYSDATE when the row was inserted (transaction or system recovery)
FORCE_TIME DATE   Time of manual force decision (null if not forced locally)
RETRY_TIME DATE NOT NULL Time automatic recovery (RECO) last tried to recover the transaction
OS_USER VARCHAR2(64)   Operating system-specific name for the end-user
OS_TERMINAL VARCHAR2(255)   Operating system-specific name for the end-user terminal
HOST VARCHAR2(128)   Name of the host machine for the end-user
DB_USER VARCHAR2(30)   Oracle user name of the end-user at the topmost database
COMMIT# VARCHAR2(16)   Global commit number for committed transactions