Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE:Huge number of DBA_DDL_LOCKS

RE:Huge number of DBA_DDL_LOCKS

From: <M.K.Jha_at_ponl.com>
Date: 4 Mar 2004 03:41:13 +0000
Message-ID: <NY834d13-5a76186b@eur.ponl.com>


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_at_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_at_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
Received on Wed Mar 03 2004 - 21:37:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US