Locking Problem - Solution

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 27 Aug 2001 13:16:30 -0700
Message-ID: <F001.00378C1E.20010827131624@fatcity.com>

Well, I think we have a solution for our mysterious locking problems.

For those of you who do not know, I sent a note out earlier this week with a mysterious problem of locks happening on an application that was running find last week .... no changes except increased user base.

We looked at everything from resource usage, bad SQL, bad application design , etc. and was unable to come up with anything.

Then.... based on a comment in an Oracle Metalink report, we looked to INITTRANS. Last Friday we increased the INITRANS on the offending tables from 1 to 2. At this point in time, no more locking problems are occuring.

Of course, after I tell this, I will look at the database and it will probably have continuous locks on it........

Thanks to all who tried to help.

Kevin
--

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

Author: Kevin Lange
  INET: kgel_at_ppoone.com

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 Mon Aug 27 2001 - 15:16:30 CDT