RE: Hierarchical query for locking

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Wed, 23 Feb 2005 14:05:08 -0600
Message-ID: <83FCA77436D6A14883E132C63F4101D002947CDB@pscdalpexch50.perotsystems.net>

Pretty much the only locking script I have ever needed is one by Steve Adam's, search for ixora and oracle and you will find his site, all his scripts are there, the script shows blockers and waiters. After I get the SID's I just grab the SQL running for each session and usually determine what the problem is.=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: Wednesday, February 23, 2005 1:37 PM To: oracle-l_at_freelists.org
Subject: Hierarchical query for locking

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=3D20 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)=3D20
  --
  http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 23 2005 - 15:08:22 CST