Re: Determining Locked user?? CATBLOCK.SQL script
Date: Wed, 30 Nov 1994 14:59:13 GMT
Message-ID: <James.Lawrence.34.000EFD1B_at_epamail.epa.gov>
In article <1994Nov25.192949.19643_at_sequent.com> krader_at_sequent.com (Kurtis D. Rader) writes:
>From: krader_at_sequent.com (Kurtis D. Rader)
>Subject: Re: Determining Locked user??
>Date: Fri, 25 Nov 94 19:29:49 GMT
>barry.roomberg_at_compudata.com (BARRY ROOMBERG) writes:
>>-> Is there any query I can use to determine which user is locking a
>>-> particular row? I cannot seem to find anything about this in the
>>-> manauls. If you give me the query and/or point me in the right
>>-> direction...
>>In Oracle 6 I had a query that would show who is holding/waiting
>>for certain locks, which I would relate to tables (not rows).
>>Those data dictionary views went away in O7, so I'm looking for
>>the same thing. Please post any response/solution you get.
In your DBA manual, appendix B, there is a script called CATBLOCK provided with your database that will create a view called blocking_locks.
Lawrence... Received on Wed Nov 30 1994 - 15:59:13 CET