RE: dba_2pc_pending transaction_id to sql_text
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Tue, 24 Feb 2015 12:04:53 +0300
Message-ID: <OFF80E14BB.DBAB484D-ON43257DF6.00316D53-43257DF6.0031E2A7_at_psbank.ru>
V$TRANSACTION doesn't show global transactions without local transaction: predicates = (BITAND(x$ktcxb."KSSPAFLG", 1) <> 0 AND BITAND(x$ktcxb."KTCXBFLG", 2) <> 0)
Date: Tue, 24 Feb 2015 12:04:53 +0300
Message-ID: <OFF80E14BB.DBAB484D-ON43257DF6.00316D53-43257DF6.0031E2A7_at_psbank.ru>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 24 2015 - 10:04:53 CET