Re: Hierarchical query for locking

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 23 Feb 2005 23:46:26 +0000 (GMT)
Message-ID: <20050223234626.9036.qmail@web86901.mail.ukl.yahoo.com>

No, but if you simply order by the duration of the lock, its normally not too difficult to see who "started" the "problem"

hth
connor

"Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS_at_GE.COM> wrote:

> Before I go and re-invent the wheel (again), does anybody
> have a hand script (that they're willing to share)
> for showing locks (and blocking locks) that utilizes the=20
> CONNECT BY PRIOR clause to make it a hierarchical query?
>
> ----
> Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)=20
> --
> http://www.freelists.org/webpage/oracle-l
>

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 23 2005 - 18:49:27 CST