Re: dba_2pc_pending transaction_id to sql_text

From: Anton <djeday84_at_gmail.com>
Date: Tue, 24 Feb 2015 11:50:09 +0300
Message-ID: <54EC3B41.5090000_at_gmail.com>

Chitale thx for reply, so if i have count of 30 in DBA_2PC_PENDING and count 0 in gv$transaction it is impossible to get failed query ?

On 02/24/2015 11:42 AM, Chitale, Hemant K wrote:
> The three elements of DBA_2PC_PENDING map to, I think, XIDUSN, XIDSLOT, XIDSQN in V$TRANSACTION.
>
> However, in this case, you should check the STATE in DBA_2PC_PENDING. The local transaction may or may not be present.
>
> Normally, for a transaction, I would join V$TRANSACTION to V$SESSION on T.ADDR=S.TADDR -- that doesn't guarantee that I can get the actual SQL for the transaction, only the session.
>
> Hemant K Chitale
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anton
> Sent: Tuesday, February 24, 2015 3:50 PM
> To: oracle-l_at_freelists.org
> Subject: dba_2pc_pending transaction_id to sql_text
>
> Hello guru of oracle-l.
> How can i check what does transaction in dba_2pc_pending do, or how to get sql text by LOCAL_TRAN_ID in dba_2pc_pending ?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html

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

Received on Tue Feb 24 2015 - 09:50:09 CET