RE:Huge number of DBA_DDL_LOCKS
- From: M.K.Jha@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: