From oracle-l-bounce@freelists.org Wed Mar 3 21:19:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i243Juf02511 for ; Wed, 3 Mar 2004 21:19:56 -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 i243Juo02506 for ; Wed, 3 Mar 2004 21:19:56 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0437C394EAB; Wed, 3 Mar 2004 22:20:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 22:19:17 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mta6.srv.hcvlny.cv.net (mta6.srv.hcvlny.cv.net [167.206.5.72]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CCDD394E58 for ; Wed, 3 Mar 2004 22:19:14 -0500 (EST) Received: from sseerang (ool-4355ee3f.dyn.optonline.net [67.85.238.63]) by mta6.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with SMTP id <0HU1000LC82MJA@mta6.srv.hcvlny.cv.net> for oracle-l@freelists.org; Wed, 03 Mar 2004 22:23:11 -0500 (EST) Date: Wed, 03 Mar 2004 23:20:39 -0500 From: Jay Subject: Huge number of DBA_DDL_LOCKS To: oracle-l@freelists.org Message-id: MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4925.2800 X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Content-Type: text/plain; charset=iso-8859-1 Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-archive-position: 277 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jaysingh1@optonline.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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 -----------------------------------------------------------------