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 266A8196140D for ; Fri, 9 Sep 2016 15:39:01 +0200 (CEST) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Fri, 9 Sep 2016 15:39:01 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B8652CA5E; Fri, 9 Sep 2016 09:38:59 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1473428339; bh=9EF69pIAW1dvDicslosygdBlJMssqyAmj/92JnEKaOY=; h=Date:From:To:Cc:Subject:References:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=cA5Osx3Otgk40CvoUxSB59StBQf9VM2cdEnTtb5emH9WB8tM4cIl585CSQlglE/yK 7W1d/xa7ILLVN4eRe1BDwghXUiZIJUDH24DcbS8zBbVuMsHpWm/nwWTWN+6wAXLHeA dfLIN215ommZASqIDeYQsTehBizrcYI/LvgZvYD0= 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 pDRRm0BL5DPo; Fri, 9 Sep 2016 09:38:59 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B7322CA49; Fri, 9 Sep 2016 09:38:46 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1473428339; bh=9EF69pIAW1dvDicslosygdBlJMssqyAmj/92JnEKaOY=; h=Date:From:To:Cc:Subject:References:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=cA5Osx3Otgk40CvoUxSB59StBQf9VM2cdEnTtb5emH9WB8tM4cIl585CSQlglE/yK 7W1d/xa7ILLVN4eRe1BDwghXUiZIJUDH24DcbS8zBbVuMsHpWm/nwWTWN+6wAXLHeA dfLIN215ommZASqIDeYQsTehBizrcYI/LvgZvYD0= Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Sep 2016 09:37:24 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BEB32C9CB for ; Fri, 9 Sep 2016 09:37:24 -0400 (EDT) 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 ODclymdiCvlG for ; Fri, 9 Sep 2016 09:37:24 -0400 (EDT) Received: from nm15-vm6.bullet.mail.gq1.yahoo.com (nm15-vm6.bullet.mail.gq1.yahoo.com [98.137.176.78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 3B58C2C9C2 for ; Fri, 9 Sep 2016 09:37:23 -0400 (EDT) Received: from [98.137.12.174] by nm15.bullet.mail.gq1.yahoo.com with NNFMP; 09 Sep 2016 13:37:22 -0000 Received: from [98.137.12.215] by tm13.bullet.mail.gq1.yahoo.com with NNFMP; 09 Sep 2016 13:37:22 -0000 Received: from [127.0.0.1] by omp1023.mail.gq1.yahoo.com with NNFMP; 09 Sep 2016 13:37:22 -0000 Received: from jws10761.mail.gq1.yahoo.com by sendmailws126.mail.gq1.yahoo.com; Fri, 09 Sep 2016 13:37:22 +0000; 1473428242.526 Date: Fri, 9 Sep 2016 13:37:22 +0000 (UTC) From: "Yong Huang" (Redacted sender "yong321" for DMARC) To: Oracle-l Digest Users Cc: "lsantos@pobox.com" Message-ID: <1986011603.1839367.1473428242320@mail.yahoo.com> Subject: Re: Holder query in lock MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit References: <1986011603.1839367.1473428242320.ref@mail.yahoo.com> X-archive-position: 66179 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: dmarc-noreply@freelists.org Precedence: normal Reply-To: dmarc-noreply@freelists.org 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 > But is there a simple way (without any trace) to discover to the > SQL_ID that locked the rows related to blocker lock? This is a feature Oracle should have provided a long time ago because so many people have asked for it. I filed a feature request. (For those who can see, it is: "Severity 4 SR 3-12200129251 : Request for ID of SQL responsible for transaction to be added to v$transaction") As far as I know, unless you trace or audit the session from at least the point the transaction starts, or using LogMiner (as Stefan and Dominic suggested), there's no reliable way to find the initial DML SQL that creates the transaction. I have checked data dictionary for any possible view that contains both SCN and SQL columns, and all events related to transactions. Yong Huang -- http://www.freelists.org/webpage/oracle-l