Re: System state dump

Hi Chuck,

Oracle has actually published this info. See MetaLink Doc. ID 122793.1. It outlines two techniques: One utilizing systemstate dump analysis and one using X$KGLLK.

Hope that helps,

-Mark

"Chuck" <chuckh_at_softhome.net> wrote in message news:<anhh60$cupeo$1_at_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 Sat Oct 05 2002 - 21:00:09 CDT