From oracle-l-bounce@freelists.org Tue Jun 15 02:01:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5F71Kp28133 for ; Tue, 15 Jun 2004 02:01:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5F71A628085 for ; Tue, 15 Jun 2004 02:01:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DCD0C72C18B; Tue, 15 Jun 2004 01:45:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13306-29; Tue, 15 Jun 2004 01:45:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3662F72C090; Tue, 15 Jun 2004 01:45:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 15 Jun 2004 01:44:33 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C557D72C03D for ; Tue, 15 Jun 2004 01:44:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11571-91 for ; Tue, 15 Jun 2004 01:44:32 -0500 (EST) Received: from az18nt143.honeywell.com (az18nt143.honeywell.com [199.64.7.143]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4528572C00B for ; Tue, 15 Jun 2004 01:44:32 -0500 (EST) Received: from tmpcn683.honeywell.com ([131.127.249.99]) by az18nt143.honeywell.com with InterScan Messaging Security Suite; Tue, 15 Jun 2004 00:04:16 -0700 Received: from az18hb522.honeywell.com (az18hb522.allied.com [131.127.249.91]) by tmpcn683.honeywell.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id M4B1DK63; Tue, 15 Jun 2004 00:04:16 -0700 Received: by az18hb522.allied.com with Internet Mail Service (5.5.2657.72) id ; Tue, 15 Jun 2004 00:04:16 -0700 Message-ID: <77ED2BF75D59D1439F90412CC5B109740D8D8D28@ie10-sahara.hiso.honeywell.com> From: "Naveen, Nahata (IE10)" To: oracle-l@freelists.org Subject: RE: sql stmt causing lock Date: Tue, 15 Jun 2004 00:10:36 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2728 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Naveen.Nahata@honeywell.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If by recycled you mean shutdown and started again, AFAIK you cannot get this information. Oracle stores information only on the current locks held. If Oracle started storing information about all the locks it acquires, in persistent objects, you will run out of space very soon. Regards Naveen > >Hi , > Can I know the sql which caused a lock on table after the database >has been recycled. >Which table can give this info.Also is it possible to know >which program >caused the lock. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------