Re: Oracle table locks
Date: 1995/09/27
Message-ID: <44cj1r$faq_at_crchh327.rich.bnr.ca>#1/1
Mohinder Singh <msingh_at_ingr.com> wrote:
>Hi,
>
>Is there a software tool or script available which can continously
>monitor table locks and log it to a file, and also tell me which
>SQL statement has placed a table lock or caused a table to be
>exclusively locked. I have situation here, where
>once in a while all the workstation attached to Oracle 7.0 database
>will freeze up and any other query will not generate a response.
>Viewing table locks thru SQLDBA tells me which table
>are locked, but I don't know why they are locked, since our application
>does not place any exclusive locks on tables.
>
>Any help on this matter will be much appreciated.
>
>Thank.
>
>Mo
>
>email: msingh_at_ingr.com
>
>
The product I am familiar with is UniVision by Platinum Technologies.
Received on Wed Sep 27 1995 - 00:00:00 CET