This could be a problem, but not neccesarily For example in a database with 29 sessions I have this select lock_type,count(*) from dba_locks group by lock_type LOCK_TYPE COUNT(*) -------------------------- --------------------------------------- Media Recovery 11 Redo Thread 1 Temp Segment 1 Transaction 5 XR 1 As you see there are several type of locks ----- Original Message ----- From: "Jay" <jaysingh1@xxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, March 04, 2004 12:20 AM Subject: Huge number of DBA_DDL_LOCKS > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------