RE: Hierarchical query for locking
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <MATT.ADAMS@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Feb 2005 08:31:20 +1100
Matt,
Is ?\rdbms\admin\utllockt.sql an option for you?
As documented in the script, note 2 disadvantages:
One, a table is created when this script is run. To create a table =
a number of locks must be
acquired. This might cause the session running the script to get =
caught in the lock problem it is trying to diagnose. =20
Two, if a session waits on a lock held by more than one session (share =
lock) then the wait-for graph is no longer a tree and the connect-by =
will show the session (and any sessions waiting on it) several times.
Bruce Reardon
-----Original Message-----
From Adams, Matthew (GE
Consumer & Industrial)
Sent: Thursday, 24 February 2005 6:37 AM
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
NOTICE
This e-mail and any attachments are private and confidential and may =
contain privileged information. If you are not an authorised recipient, =
the copying or distribution of this e-mail and any attachments is =
prohibited and you must not read, print or act in reliance on this =
e-mail or attachments.
This notice should not be removed.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
