Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> statspack.snap hung on library cache pin

statspack.snap hung on library cache pin

From: <DEEDSD_at_Nationwide.com>
Date: Thu, 18 Mar 2004 13:48:33 -0500
Message-ID: <OF156C9E97.7C20DED9-ON85256E5B.0065EEEA@lnotes-gw.ent.nwie.net>

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_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 Thu Mar 18 2004 - 13:26:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US