waiting on library cache locks

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Mon, 8 Mar 2004 07:47:44 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C028EEA91@uswaumsx14medge.med.ge.com>

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 Mon Mar 08 2004 - 07:46:33 CST