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
Received on Wed Sep 27 1995 - 00:00:00 CET