Re: Discovering Possible Deadlock...?

v$lock does not report library cache locks. Run catblock.sql and look at dba_lock and dba_lock_internal. v$session_wait should help in general sense.

If you get deadlocks, you'll get udump trace files that tell you so. Suppose you get ORA-4020, do this (from Steve Adams):

alter session set events '4020 trace name processstate forever, level 10';

and next time you get a deadlock, you'll get a deadlock "graph". I have a very basic, short article on this at
http://www.stormloader.com/yonghuang/computer/deadlocks.txt

Yong Huang
yhuang_at_indigopool.com

Dave A <dave_and_vanna_at_hotmail.com> wrote in message news:stqeiqljad876a_at_corp.supernews.com...
> v$lock, v$sessionwait...
>
> --
> Dave A
>
>
> "fooguy" <jweisen_at_my-deja.com> wrote in message
> news:8rd9bd$73d$1_at_nnrp1.deja.com...
> > Our (poorly designed) Accounts Receivable software is a ~300MB (that's
> > right, 300MB. 20 users - what a waste of Oracle) database running under
> > Oracle 7.3.3 on OpenVMS. Performance has begun to degrade again, and
> > despite updating statistics, reindexing, it's just not what it used to
> > be. I'm thinking it's time to dump and reload.
> >
> > We have one Crystal Report, however, that sometimes takes 40 minutes to
> > run, and sometimes only takes 2. When it's running, the system has no
> > I/O, just 100% CPU utilization. I ran an Explain Plan on the SQL string
> > that the report is based on, and it took almost 2 hours to do that. I'm
> > wondering if it's hitting a deadlock. Is there a view that would report
> > that, or some sort of debugging feature that might tell me what's going
> > on?
> >
> > Suggestions, thoughts, opinions are appreciated.
> >
> > Thanks,
> > John
> >
> > --
> > *********************************************
> > "All I every wanted from life was to see
> > Larry Wall give Bill Gates a Perl Necklace."
> >
> > /*
> > John Eisenschmidt
> > fooguy AT AT AT eisenschmidt DOT DOT DOT org
> > (you know the drill)
> > */
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Oct 06 2000 - 16:11:55 CDT