From kgel@ppoone.com Mon, 27 Aug 2001 13:16:30 -0700 From: Kevin Lange Date: Mon, 27 Aug 2001 13:16:30 -0700 Subject: Locking Problem - Solution Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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).