From oracle-l-bounce@freelists.org Wed Jun 2 09:23:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i52EMkZ19265 for ; Wed, 2 Jun 2004 09:22:56 -0500 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 i52EMa619230 for ; Wed, 2 Jun 2004 09:22:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F25172C8B4; Wed, 2 Jun 2004 09:09:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18241-73; Wed, 2 Jun 2004 09:09:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62B1572C779; Wed, 2 Jun 2004 09:09:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 02 Jun 2004 09:07:56 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7369E72C3FE for ; Wed, 2 Jun 2004 09:07:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18241-34 for ; Wed, 2 Jun 2004 09:07:55 -0500 (EST) Received: from smtp101.mail.sc5.yahoo.com (smtp101.mail.sc5.yahoo.com [216.136.174.139]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 64CFA72C7F7 for ; Wed, 2 Jun 2004 09:07:54 -0500 (EST) Received: from unknown (HELO DC) (diegocutrone@200.73.128.77 with login) by smtp101.mail.sc5.yahoo.com with SMTP; 2 Jun 2004 14:26:08 -0000 Message-ID: <004b01c448cf$746b5d80$4d8049c8@DC> From: "Diego Cutrone" To: References: Subject: Re: library cache lock Date: Wed, 2 Jun 2004 11:28:42 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003E_01C44894.C2518AA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1767 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: diegocutrone@yahoo.com.ar Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------=_NextPart_000_003E_01C44894.C2518AA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable library cache lockDave, To find out which session is blocking you you can also try this one: select sid Holder ,KGLLKUSE Sesion , KGLLKMOD Held, KGLLKREQ Req from x$kgllk , v$session where KGLLKHDL in (select p1raw from v$session_wait=20 where wait_time=3D0 and event like 'library cache = lock%') and KGLLKMOD <> 0 and v$session.saddr=3Dx$kgllk.kgllkuse=20 / Then after identifying the blocking session, you can go from there HTH Regards, Diego ----- Original Message -----=20 From: David Sharples=20 To: oracle-l@freelists.org=20 Sent: Wednesday, June 02, 2004 5:44 AM Subject: library cache lock Hi, got a strange problem. I am trying to truncate a partition in a = table, but it just hangs forever, it is waiting on a library cache lock. = Anyone know why and how I can clear it - flushing the shared pool = didn't help and there are no other sessions touching that table. Thanks Dave ------=_NextPart_000_003E_01C44894.C2518AA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable library cache lock
Dave,
 
To find out which session is blocking = you you can=20 also try this one:
 
select sid Holder ,KGLLKUSE Sesion , = KGLLKMOD Held,=20 KGLLKREQ Req
from x$kgllk , v$session
where KGLLKHDL in (select = p1raw from=20 v$session_wait=20
           &nb= sp;       =20 where wait_time=3D0 and event like 'library cache lock%')
and = KGLLKMOD <>=20 0
and v$session.saddr=3Dx$kgllk.kgllkuse
/
Then after identifying the blocking = session, you=20 can go from there
 
HTH
Regards,
Diego
 
 
----- Original Message -----
From:=20 David Sharples =
Sent: Wednesday, June 02, 2004 = 5:44=20 AM
Subject: library cache = lock

Hi, got = a strange=20 problem.  I am trying to truncate a partition in a table, but it = just=20 hangs forever, it is waiting on a library cache = lock.  Anyone know why and how I can clear = it = =96 flushing = the=20 shared pool didn=92t = help and there are=20 no other sessions touching that table.

Thanks

Dave

------=_NextPart_000_003E_01C44894.C2518AA0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------