Re: Hierarchical query for locking
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Feb 2005 23:46:26 +0000 (GMT)
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@xxxxxx> 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@xxxxxxxxxxx
> "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
> --
> //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@xxxxxxxxx
"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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
