DBA_2PC_PENDING

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

Related Commands: