Hierarchical query for locking

From: Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_GE.COM>
Date: Wed, 23 Feb 2005 14:36:47 -0500
Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F009CF7283@LOUMLVEM01.e2k.ad.ge.com>

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

Received on Wed Feb 23 2005 - 14:38:15 CST