From oracle-l-bounce@freelists.org Fri Apr 2 00:07:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3267dG22118 for ; Fri, 2 Apr 2004 00:07:39 -0600 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 i3267co22112 for ; Fri, 2 Apr 2004 00:07:39 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 880C5634C74; Fri, 2 Apr 2004 01:03:52 -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 16229-27; Fri, 2 Apr 2004 01:03:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DBD82634CDC; Fri, 2 Apr 2004 01:03:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Apr 2004 01:02:46 -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 0DF6E634CB0 for ; Fri, 2 Apr 2004 01:02:46 -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 15297-70 for ; Fri, 2 Apr 2004 01:02:45 -0500 (EST) Received: from einsteinium.btinternet.com (einsteinium.btinternet.com [194.73.73.147]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC5A3634CA4 for ; Fri, 2 Apr 2004 01:02:45 -0500 (EST) Received: from [81.132.155.167] (helo=Primary) by einsteinium.btinternet.com with smtp (Exim 3.22 #25) id 1B9Htd-0005EG-00 for oracle-l@freelists.org; Fri, 02 Apr 2004 07:11:17 +0100 Message-ID: <016401c41879$53087870$7102a8c0@Primary> From: "Jonathan Lewis" To: References: <1C9727B12F498543A43CBB988F30515C02F3AFDC@uswaumsx14medge.med.ge.com> Subject: Re: table locked from n minutes Date: Fri, 2 Apr 2004 07:11:23 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2374 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If you look in v$lock for the row of type TM, and check the CTIME column - this is roughly the time (in seconds, to the nearest 3) that the table has been locked, or a request has been waiting. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar ----- Original Message ----- From: "Kommareddy, Srinivas (MED, Wissen Infotech)" To: Sent: Friday, April 02, 2004 5:40 AM Subject: table locked from n minutes Hi All, Is there a way to know that a table has been locked for n minutes ? ( Because a session may lock it and release it several times (depending up on the code). ) We have a requirement to kill a session if it locks a table for n minutes. Can somebody through somelight on this ? Thanks and Regards, Srinivas ---------------------------------------------------------------- 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 -----------------------------------------------------------------