Re: dba_2pc_pending transaction_id to sql_text

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/>

--
http://www.freelists.org/webpage/oracle-l