From oracle-l-bounce@freelists.org Wed Mar 3 21:37:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i243b3V03457 for ; Wed, 3 Mar 2004 21:37:03 -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 i243b3o03452 for ; Wed, 3 Mar 2004 21:37:03 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BDC5C394EE9; Wed, 3 Mar 2004 22:37:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 22:36:23 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail2-out.ponl.com (mail2-out.ponl.com [57.79.201.33]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CB39394E7E for ; Wed, 3 Mar 2004 22:36:20 -0500 (EST) Received: from mailscan4.poceur1 (mailscan4 [57.193.70.32]) by mail2-out.ponl.com (PONL Mail Server) with SMTP id D8CEB69C for ; Thu, 4 Mar 2004 03:38:51 +0000 (UCT) Received: from nodnsquery(57.193.36.54) by mailscan4.poceur1 via csmap id 7545df54_6d8d_11d8_8397_003048290be9_2253; Thu, 04 Mar 2004 03:38:53 +0000 (UTC) X-Internal-ID: 4026C710000A8D08 Received: from eur.ponl.com (57.193.36.54) by gblongc4.poceur1 (NPlex 2.0.108) for oracle-l@freelists.org; 4 Mar 2004 03:41:13 +0000 Message-ID: Date: 4 Mar 2004 03:41:13 +0000 From: M.K.Jha@ponl.com To: oracle-l@freelists.org Subject: RE:Huge number of DBA_DDL_LOCKS X-NAIMIME-Disclaimer: 1 Content-Type: Text/Plain X-NAIMIME-Modified: 1 X-archive-position: 278 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: M.K.Jha@ponl.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Orig-Date: Thu, 4 Mar 2004 15:37:00 0000 Not need to worry if most of lock are of "MODE_HELD"= 'NULL' type. ==================== Dear All, Why these many DDL locks? Is something wrong in this environment? Or it is normal to have 20k+ locks? If it is not okay where should I start investigating this issue? Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production With the Partitioning and Parallel Server options JServer Release 8.1.7.3.0 - Production SQL> select count(*) from dba_ddl_locks; COUNT(*) ---------- 21318 SQL> select count(*) from dba_dml_locks; COUNT(*) ---------- 3 SQL> ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ------------------------------------------------------------------------------ The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete the e-mail and other copies of it from your computer system. Thank you. We believe this email to be virus free but do not warrant that this is the case and we will not accept liability for any losses arising from any virus being transmitted unintentionally by us. We reserve the right to monitor all E-mail communications through our network ---------------------------------------------------------------- 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 -----------------------------------------------------------------