Table Locks

From: Alroy Mascranghe <alroy_at_informatics.lk>
Date: Tue, 12 Feb 2002 04:39:46 -0800
Message-ID: <F001.0040C726.20020212043318@fatcity.com>

Hi all

We are running on 8.0.5.2.1 database. Once we had a database creash and was restored. After that the users have been experiencing locks. What happens is when one user locks some rows, other users are also getting stuck. But they are not locking the same rows. We are looking at the code to see whether any unusual things are there. One of the programs in the system uses DBMS_ALERT.

How can we find more information - what rows are being locked, and any other relevant info about locks?

Is there any ways in which a row locks turns out to be a table lock ?

Thanks
Alroy
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alroy Mascranghe
  INET: alroy_at_informatics.lk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 12 2002 - 06:39:46 CST