Re: [HELP] How can I find deadlocks?

From: Marc <marcm_at_computek.net>
Date: 1997/04/28
Message-ID: <33649A60.167E@computek.net>#1/1

Manoli Alamo Medina wrote:
>
> Hi,
>
> I have a problem about deadlocks in ORACLE V7.1.4.
> Could anybody help me, about how to find them?
>
> (Please, send a copy of your post to mailto:sscc.malamo_at_aena.es)
>
> Thanks in advance!
> Manoli Alamo

We have a set of utilities which do lots of things - one of which is report on dead locks in the DB. There are two such reports:

	lstlock - List all dependent locks
	lstslock - List dependent single pass locks 

You can download these utilities from
	 http://dbghome.computek.net. If

you are running on UNIX. If you are on another platform then you can use the html version 2.0 which runs on most platforms using PERL and html.

Hope this helps,
Marc

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->

Received on Mon Apr 28 1997 - 00:00:00 CDT