System state dump

From: Chuck <chuckh_at_softhome.net>
Date: Thu, 3 Oct 2002 09:37:00 -0400
Message-ID: <anhh60$cupeo$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----

Hash: SHA1

Is there any information available on how to interpret the results of a system state dump? Specifically I want to know who is holding and waiting on library cache locks, library cache pins, and row cache locks. I have had an ongoing problem with materialized view refreshes hanging, and when I query v$session_wait I find dozens of sessions waiting on these events for long periods of time. OTS has been able to tell me what session is causing the problem from these dumps but I'd rather be able to determine it myself so I can debug the problem without having to wait for them all the time. - --
Chuck

-----BEGIN PGP SIGNATURE-----

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPZxH+VVYIIV9CtSHEQKJmACg6n8jOsMCyauTY5e3UU0tX0tIqCcAn2yo qww9X4Z4nHEOlIMTu/jB+jA6
=F+8A
-----END PGP SIGNATURE-----
Received on Thu Oct 03 2002 - 08:37:00 CDT