Re: dba_2pc_pending transaction_id to sql_text
- From: Anton <djeday84@xxxxxxxxx>
- To: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- Date: Tue, 24 Feb 2015 13:30:06 +0300
no luck =(
SQL> select local_tran_id,state from DBA_2PC_PENDING where rownum <2;
LOCAL_TRAN_ID STATE
---------------------- ----------------
81.15.256681 prepared
SQL> select KXIDUSN,KXIDSLT,KXIDSQN from sys.x$ktcxb where KXIDUSN=81;
no rows selected
On 02/24/2015 12:04 PM, Sayan Sergeevich Malakshinov wrote:
V$TRANSACTIONdoesn'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://orasql.org/>
Other related posts:
