Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_2PC_PENDING

info about distributed transactions awaiting recovery

Columns
   ___________________________
 
   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:



Simon Sheppard
SS64.com