Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Reply !Locking issue

Reply !Locking issue

From: Rakesh Gupta <>
Date: Wed, 22 Aug 2001 12:55:30 -0700
Message-ID: <>

I had similar problem with my database and that was due to MTS. Disabling MTS resolved the locking issue. I think this has been resolved in the newer versions of oracle8.


We have an application that, litterally overnight, developed locking issues.

Our users start working just fine. Then, right now cause unknown, our inserts start being blocked. Usually there are so many so fast that we do not even know what is causing the original lock.

The tables the users are being blocked from have multiple triggers and the tables that these triggers point to ofen have triggers of their own.

So, the scenario is

1.  Web Application pointing to an Oracle 8.0.5 database.
2. Things start out just fine.
3. At a variable time later (i.e.  not the same time of day, not the same cumulated 
time since startup, etc.) locks start to appear against our main table. The users getting the locks are trying to insert a record. 4. Locks cascade until the only recourse is to restart the database.

We are having trouble tracing the locks back to their origin. There has got to be 1 thing that is causing the start of this cascade.

If anyone has any insights on how to find this one cause ... I would appreciate hearing them.

And , if you happen to have any scripts that would help me trace the locks thru the database I would appreciate them also.


Please see the official ORACLE-L FAQ:

Author: Rakesh Gupta

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: (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 Wed Aug 22 2001 - 14:55:30 CDT

Original text of this message