Library Cache Lock 2005-01-12 - By Jeremiah Wilton
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 (See ORA-600.ora-code.com) Consulting
Emergencies - Seminars - Hiring
http://www.ora-600 (See ora-600.ora-code.com).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
|
|
