Re: library cache lock

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Wed, 12 Jan 2005 14:49:57 -0800 (PST)
Message-ID: <Pine.LNX.4.60.0501121438290.3384@cpq7598>

On Wed, 12 Jan 2005, Barr, Stephen wrote:

> We have a situation where a majority of the sessions in the database are
> waiting for "library cache lock".

First find the LC lock holder. There is a good script for this in Metalink note 122793.1.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=122793.1

Any reason you are not using online ("non-blocking") index rebuild?

--
Jeremiah Wilton
ORA-600 Consulting
Emergencies - Seminars - Hiring
http://www.ora-600.net



> ...

> 

> EVENT                                                              COUNT(*)

> ---------------------------------------------------------------- ----------

> library cache lock                                                       13

>

> ...

>

> The only activity currently happening on the database is a rebuild of the

> partitioned indexes on a single table (WH_BILLS)...

>

> Session 1

> ALTER INDEX dw_owner.il_bills_001 REBUILD PARTITION p_bills_1998_08

> NOPARALLEL NOLOGGING

> ...

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 12 2005 - 16:51:09 CST