Re: library cache lock
- From: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>
- To: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
- Date: Wed, 12 Jan 2005 14:49:57 -0800 (PST)
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
> ...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
