From oracle-l-bounce@freelists.org Tue Jun 15 01:46:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5F6k7o25444 for ; Tue, 15 Jun 2004 01:46:17 -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 i5F6jv625421 for ; Tue, 15 Jun 2004 01:46:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 35DB772C220; Tue, 15 Jun 2004 01:30:43 -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 11162-54; Tue, 15 Jun 2004 01:30:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E91672C129; Tue, 15 Jun 2004 01:30:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 15 Jun 2004 01:29:14 -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 BFDB672C1F5 for ; Tue, 15 Jun 2004 01:29:13 -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 11162-26 for ; Tue, 15 Jun 2004 01:29:13 -0500 (EST) Received: from trend-smtp.polaris.co.in (trend-smtp.polaris.co.in [203.197.144.75]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EEA2172C1C3 for ; Tue, 15 Jun 2004 01:29:12 -0500 (EST) Received: from psldns.polaris.co.in ([192.168.111.3]) by trend-smtp.polaris.co.in (Lotus Domino Release 5.0.7) with SMTP id 2004061512271000:423194 ; Tue, 15 Jun 2004 12:27:10 +0530 Received: from 192.9.200.28 by psldns.polaris.co.in (InterScan E-Mail VirusWall NT); Tue, 15 Jun 2004 12:18:55 +0530 Subject: sql stmt causing lock Date: Tue, 15 Jun 2004 12:17:35 +0530 X-Priority: 1 (High) Importance: High MIME-Version: 1.0 To: oracle-l@freelists.org From: manoj.gurnani@polaris.co.in X-Mailer: Microsoft Outlook v 10.00.4510, MSOC v 1.00.2411.00 Message-ID: Cc: X-MIMETrack: Serialize by Router on psldns.polaris.co.in/Polaris(Release 5.0.7 |March 21, 2001) at 06/15/2004 12:18:55 PM, Serialize complete at 06/15/2004 12:18:55 PM, Itemize by SMTP Server on Trend-Smtp/Orion/IN(Release 5.0.7 |March 21, 2001) at 06/15/2004 12:27:10 PM, Serialize by Router on Trend-Smtp/Orion/IN(Release 5.0.7 |March 21, 2001) at 06/15/2004 12:27:41 PM, Serialize complete at 06/15/2004 12:27:41 PM X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Content-Type: multipart/mixed; boundary="----=_NextPartTM-000-95fcc345-a8eb-48b6-b368-517591875cc6" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2726 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: manoj.gurnani@polaris.co.in Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPartTM-000-95fcc345-a8eb-48b6-b368-517591875cc6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" 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. Thanks Manoj ------=_NextPartTM-000-95fcc345-a8eb-48b6-b368-517591875cc6 Content-Transfer-Encoding: 7bit Content-Type: text/plain; name="InterScan_Disclaimer.txt" Content-Disposition: attachment; filename="InterScan_Disclaimer.txt" This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited. Visit Us at http://www.polaris.co.in ------=_NextPartTM-000-95fcc345-a8eb-48b6-b368-517591875cc6-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------