Thanks. I'll check out the article.
"Mark J. Bobak" <mark_at_bobak.net> wrote in message
news:fe9b0e1b.0210051800.74e3bab4_at_posting.google.com...
> 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 Mon Oct 07 2002 - 07:42:24 CDT
