RE: Hierarchical query for locking

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_at_appl.ge.com

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.

--
http://www.freelists.org/webpage/oracle-l