Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table Locks

RE: Table Locks

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Tue, 12 Feb 2002 07:43:53 -0800
Message-ID: <F001.0040CA4C.20020212065827@fatcity.com>

Sounds like you have run into the much annoying problem of missing foreign key indexes. I would check that out first I think.

-----Original Message-----
Mascranghe
Sent: Tuesday, February 12, 2002 4:33 AM To: Multiple recipients of list ORACLE-L

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: ksmith2_at_myfirstlink.net 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 - 09:43:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US