Re: dba_2pc_pending transaction_id to sql_text

From: Rich <richa03_at_gmail.com>
Date: Tue, 24 Feb 2015 11:14:23 -0800
Message-ID: <CALgGkeDzRGD3n9OERQSEvOpDAhkhbB8sXOtNtnv+2YqaBpHB=w_at_mail.gmail.com>

If it's really important, you can try mining [archived] redo. On Feb 24, 2015 2:31 AM, "Anton" <djeday84_at_gmail.com> wrote:

> 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$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 - 20:14:23 CET