Hierarchical query for locking

  • From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Feb 2005 14:36:47 -0500

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

Other related posts: