Table: DBA_2PC_PENDING
info about distributed transactions awaiting recovery
| Column Name | Description |
|---|---|
| ADVICE | C for commit, R for rollback, else null |
| COMMIT# | global commit number for committed transactions |
| DB_USER | Oracle user name of the end-user at the topmost database |
| FAIL_TIME | value of SYSDATE when the row was inserted (tx or system recovery) |
| FORCE_TIME | time of manual force decision (null if not forced locally) |
| GLOBAL_TRAN_ID | globally unique transaction id |
| HOST | name of the host machine for the end-user |
| LOCAL_TRAN_ID | string of form: n.n.n, n a number |
| MIXED | yes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used) |
| OS_TERMINAL | operating system specific name for the end-user terminal |
| OS_USER | operating system specific name for the end-user |
| RETRY_TIME | time automatic recovery (RECO) last tried to recover the transaction |
| STATE | collecting, prepared, committed, forced commit, or forced rollback |
| TRAN_COMMENT | text for "commit work comment |