From oracle-l-bounce@freelists.org Thu Mar 18 14:52:52 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2IKqqf22621 for ; Thu, 18 Mar 2004 14:52:52 -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 i2IKqno22609 for ; Thu, 18 Mar 2004 14:52:50 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 55BF4395048; Thu, 18 Mar 2004 15:32:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 18 Mar 2004 15:31:24 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A7431391EC1 for ; Thu, 18 Mar 2004 14:45:02 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i2IJpDW13241 for ; Thu, 18 Mar 2004 14:51:13 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Thu, 18 Mar 2004 14:51:14 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: statspack.snap hung on library cache pin Date: Thu, 18 Mar 2004 14:51:14 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B4537A@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: statspack.snap hung on library cache pin Thread-Index: AcQNHl92fP8Bh1gXTvGRjFykLStVdgAA94ig From: "Bobak, Mark" To: X-OriginalArrivalTime: 18 Mar 2004 19:51:14.0990 (UTC) FILETIME=[5F2AB4E0:01C40D22] X-archive-position: 1176 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Dallas, Try this to identify the blocking session: select decode(lob.kglobtyp, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE', 11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY', 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB', 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE', 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE', 32, 'INDEXTYPE', 33, 'OPERATOR', 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION', 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION', 42, 'MATERIALIZED VIEW', 43, 'DIMENSION', 44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN', 48, 'CONSUMER GROUP', 51, 'SUBSCRIPTION', 52, 'LOCATION', 55, 'XML SCHEMA', 56, 'JAVA DATA', 57, 'SECURITY PROFILE', 59, 'RULE', 62, 'EVALUATION CONTEXT', 'UNDEFINED') object_type, lob.kglnaobj object_name, pn.kglpnmod lock_mode_held, pn.kglpnreq lock_mode_requested, ses.sid, ses.serial#, ses.username from v$session_wait vsw, x$kglob lob, x$kglpn pn, v$session ses where vsw.event = 'library cache pin' and vsw.p1raw = lob.kglhdadr and lob.kglhdadr = pn.kglpnhdl and pn.kglpnmod != 0 and pn.kglpnuse = ses.saddr / -----Original Message----- From: DEEDSD@Nationwide.com [mailto:DEEDSD@Nationwide.com] Sent: Thursday, March 18, 2004 1:49 PM To: oracle-l@freelists.org Subject: statspack.snap hung on library cache pin I've got a strange issue. Before anyone flames me for using statspack, let me say that I am merely performing a system-level overview on an instance. One of the capacity management folks suggested to the customer that we run statspack on their instance, so I'm doing so to keep the customer happy. My issue is that when I am trying to execute statspack.snap, it is sitting hung on library cache pin (from the trace file:) WAIT #1: nam='library cache pin' ela= 308 p1=15192228680 p2=15149503480 p3=32 WAIT #1: nam='library cache pin' ela= 308 p1=15192228680 p2=15149503480 p3=32 WAIT #1: nam='library cache pin' ela= 308 p1=15192228680 p2=15149503480 p3=32 WAIT #1: nam='library cache pin' ela= 308 p1=15192228680 p2=15149503480 p3=32 I'm running 8.1.7.2 on Solaris 8. Any ideas? ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------