RE: Hierarchical query for locking
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <MATT.ADAMS@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Feb 2005 14:05:08 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Adams, Matthew (GE
Consumer & Industrial)
Sent: Wednesday, February 23, 2005 1:37 PM
To: oracle-l@xxxxxxxxxxxxx
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@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)=3D20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
