RE: waiting on library cache locks

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Wed, 10 Mar 2004 03:58:12 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B1097408A8A22A@ie10-sahara.hiso.honeywell.com>

You are spot on. Any DDL on the table invalidates the trigger, and a trigger needs to get a lock on the table definition in the library cache while creating.

You can find which object it is waiting on by joining P1RAW column to KGLHDADR column in X$KGLOB table.

Regards
Naveen
-----Original Message-----

From: Kommareddy, Srinivas (MED, Wissen Infotech) [mailto:Srinivas.Kommareddy_at_med.ge.com]
Sent: Monday, March 08, 2004 7:18 PM
To: oracle-l_at_freelists.org
Subject: waiting on library cache locks

Hi all,

DB:9i Solaris 2.8

When I tried to enable a trigger , its hung for long time. I checked the sessions for any waits. I see that the session is waiting on library cache locks.

i further checked and found that the trigger was dependent on a table which is being analyzed that time.

Can someone thorugh some light on this. Is the above case true or Is there any other reson for the LC lock ?

Tx and Regards,
Srinivas

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Mar 10 2004 - 04:49:01 CST