VIEW: SYS.DBA_PENDING_TRANSACTIONS

Source

View Text - Preformatted

(((select formatid, globalid, branchid
   from   gv$global_transaction
   where  preparecount > 0 and refcount = preparecount)
 minus
  (select global_tran_fmt, global_foreign_id, branch_id
   from   sys.pending_trans$ tran, sys.pending_sessions$ sess
   where  tran.local_tran_id = sess.local_tran_id
     and  tran.state != 'collecting'
     and  dbms_utility.is_bit_set(tran.session_vector, sess.session_id)=1)
 )
 union
  (select global_tran_fmt, global_foreign_id, branch_id
   from   sys.pending_trans$ tran, sys.pending_sessions$ sess
   where  tran.local_tran_id = sess.local_tran_id
     and  tran.state != 'collecting'
     and  dbms_utility.is_bit_set(tran.session_vector, sess.session_id)=1)
)

View Text - HTML Formatted

(((SELECT FORMATID
, GLOBALID
, BRANCHID
FROM GV$GLOBAL_TRANSACTION
WHERE PREPARECOUNT > 0
AND REFCOUNT = PREPARECOUNT) MINUS (SELECT GLOBAL_TRAN_FMT
, GLOBAL_FOREIGN_ID
, BRANCH_ID
FROM SYS.PENDING_TRANS$ TRAN
, SYS.PENDING_SESSIONS$ SESS
WHERE TRAN.LOCAL_TRAN_ID = SESS.LOCAL_TRAN_ID
AND TRAN.STATE != 'COLLECTING'
AND DBMS_UTILITY.IS_BIT_SET(TRAN.SESSION_VECTOR
, SESS.SESSION_ID)=1) ) UNION (SELECT GLOBAL_TRAN_FMT
, GLOBAL_FOREIGN_ID
, BRANCH_ID
FROM SYS.PENDING_TRANS$ TRAN
, SYS.PENDING_SESSIONS$ SESS
WHERE TRAN.LOCAL_TRAN_ID = SESS.LOCAL_TRAN_ID
AND TRAN.STATE != 'COLLECTING'
AND DBMS_UTILITY.IS_BIT_SET(TRAN.SESSION_VECTOR
, SESS.SESSION_ID)=1) )