Re: statspack.snap hung on library cache pin
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Mar 2004 11:43:07 -0800
Try http://www.ixora.com.au/scripts/sql/executing_packages.sql
to determine what it holding up statspack.
You may need to modify the SQL a bit to show the addresses.
The p1 value is the handle address and p2 is the pin address.
You will find this info in the 'Reference' manual in one of the
appendices.
Jared
DEEDSD@xxxxxxxxxxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03/18/2004 10:48 AM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
