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 |