From oracle-l-bounce@freelists.org Mon Mar 8 07:46:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i28DkXH21042 for ; Mon, 8 Mar 2004 07:46:33 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i28DkJo20994 for ; Mon, 8 Mar 2004 07:46:19 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1774394A93; Mon, 8 Mar 2004 08:45:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 08 Mar 2004 08:43:26 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ext-ch1gw-3.online-age.net (ext-ch1gw-3.online-age.net [216.34.191.37]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8F196394C88 for ; Mon, 8 Mar 2004 08:43:16 -0500 (EST) Received: from int-ch1gw-2.online-age.net (int-ch1gw-2 [3.159.232.66]) by ext-ch1gw-3.online-age.net (8.12.9/8.12.9/990426-RLH) with ESMTP id i28DllGi014990 for ; Mon, 8 Mar 2004 08:47:48 -0500 (EST) Received: from uswaumsxb1medge.med.ge.com (localhost [127.0.0.1]) by int-ch1gw-2.online-age.net (8.12.9/8.12.3/990426-RLH) with ESMTP id i28Dlk1l023618 for ; Mon, 8 Mar 2004 08:47:47 -0500 (EST) Received: by uswaumsxb1medge.med.ge.com with Internet Mail Service (5.5.2656.59) id ; Mon, 8 Mar 2004 07:47:46 -0600 Message-ID: <1C9727B12F498543A43CBB988F30515C028EEA91@uswaumsx14medge.med.ge.com> From: "Kommareddy, Srinivas (MED, Wissen Infotech)" To: oracle-l@freelists.org Subject: waiting on library cache locks Date: Mon, 8 Mar 2004 07:47:44 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40513.EF05B543" X-archive-position: 92 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Srinivas.Kommareddy@med.ge.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40513.EF05B543 Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C40513.EF05B543 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01C40513.EF05B543-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------