Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 5B0E719602EA for ; Tue, 3 Mar 2015 13:09:51 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Tue, 3 Mar 2015 13:09:51 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AA46C267AC; Tue, 3 Mar 2015 07:09:50 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=fail (verification failed; insecure key) header.i=@gmail.com; dkim-adsp=none (insecure policy) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id G4lbbewX9VFQ; Tue, 3 Mar 2015 07:09:50 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 49F33266CC; Tue, 3 Mar 2015 07:09:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 03 Mar 2015 07:08:12 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82A8A26691 for ; Tue, 3 Mar 2015 07:08:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zTFTUQLA+yZG for ; Tue, 3 Mar 2015 07:08:12 -0500 (EST) Received: from mail-ig0-f181.google.com (mail-ig0-f181.google.com [209.85.213.181]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6325326598 for ; Tue, 3 Mar 2015 07:08:12 -0500 (EST) Received: by igkb16 with SMTP id b16so26389032igk.1 for ; Tue, 03 Mar 2015 04:08:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=+JGmIQgL86Gou5WPscmQwAmkFz6JiWTpXgosJC5DUHo=; b=jOYNmR5t1IHDrIjsjlgWwxmOkIg7DJoGg1UTcUbjahrkVV47sDcZzOhDXK4XNNJ354 gQDck0jqusXK+gnYGR8pApxLVJQhSmqy8iuboIy3pcszpg8CKbsAgWTD3SL1WWny+1+8 Vrwo+HsFfxr91BJMxRK2S2bmDBuvOwJem3ZXM4tf/FGDVCsCM90Z7+uS61F1YIvfcQB9 j2gIpzmjZzZ7YbAeRSDIMWmyyfd+4yw4Y6VjObW5js8TRvxt/AJc55J1AuJw2r35l+pM VH1wDPxlb8JKoYDQlD61WHmvuXUDVaALWBuJozCb8LbMZZQjAy/NkOIc5zwjvvSKd72d Vyjw== MIME-Version: 1.0 X-Received: by 10.182.165.70 with SMTP id yw6mr20390789obb.13.1425384491978; Tue, 03 Mar 2015 04:08:11 -0800 (PST) Received: by 10.202.194.195 with HTTP; Tue, 3 Mar 2015 04:08:11 -0800 (PST) In-Reply-To: <54EC2D11.5010407@gmail.com> References: <54EC2D11.5010407@gmail.com> Date: Tue, 3 Mar 2015 13:08:11 +0100 Message-ID: Subject: Re: dba_2pc_pending transaction_id to sql_text From: Igor Racic To: djeday84@gmail.com Cc: "oracle-l@freelists.org" Content-Type: multipart/alternative; boundary=001a11c30c625015860510613060 X-archive-position: 58919 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: igor.racic@gmail.com Precedence: normal Reply-To: igor.racic@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001a11c30c625015860510613060 Content-Type: text/plain; charset=UTF-8 Hi, I think that your best bet would be to match info you have with info logged by transaction "participants', whoever they are (on app side). Regards, Igor 2015-02-24 8:49 GMT+01:00 Anton : > 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 > > > --001a11c30c625015860510613060 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,=C2=A0

I think that your best bet wo= uld be to match info you have with info logged by transaction "partici= pants', whoever they are (on app side).=C2=A0

= Regards,
Igor


2015-02-24 8:49 GMT+01:00 Anton <djeday= 84@gmail.com>:
Hello guru o= f 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 ?

--
htt= p://www.freelists.org/webpage/oracle-l



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