RE: dba_2pc_pending transaction_id to sql_text

  • From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
  • To: Anton <djeday84@xxxxxxxxx>
  • Date: Tue, 24 Feb 2015 12:04:53 +0300

V$TRANSACTION doesn't show global transactions without local transaction:
predicates = (BITAND(x$ktcxb."KSSPAFLG", 1) <> 0 AND 
BITAND(x$ktcxb."KTCXBFLG", 2) <> 0)

So you can check underlying x$ktcxb(KXIDUSN,KXIDSLT,KXIDSQN) for your 
local_trans_id.

--
Best regards,
Sayan Malakshinov
http://orasql.org

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2015