DBA_2PC_PENDING
info about distributed transactions awaiting recoveryColumns
___________________________
LOCAL_TRAN_ID
string of form: n.n.n,n a number
GLOBAL_TRAN_ID
globally unique transaction id
STATE
collecting,prepared,committed,forced commit or forced rollback
MIXED
yes = of the transaction committed and part rolled back (commit or rollback with the FORCE option was used)
ADVICE
C for commit,R for rollback,else null
TRAN_COMMENT
"text for "commit
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)
RETRY_TIME
time automatic recovery (RECO) last tried to recover the transaction
OS_USER
operating system specific name for the end-user
OS_TERMINAL
operating system specific name for the end-user terminal
HOST
name of the host machine for the end-user
DB_USER
Oracle user name of the end-user at the topmost database
COMMIT#
global commit number for committed transactions
Related: