Oracle-L: RE: Database Hung with all processes waiting on locks

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Mon, 01 Jul 2002 12:08:22 -0800
Message-ID: <F001.0048D2B3.20020701120822@fatcity.com>

Mary,

> We don't plan to use MTS for 11i just during the AUTOUPGRADE
> process from 10.7 to 11i. We found that it runs 20% faster
> with MTS because the workers logon/off thousands of times.
>
> And yes MTS is configured with with large pool. Thanks for
> the feedback.

Did Oracle Support suggest that you use MTS? If not, such problems may not be looked at in case you get stuck with an iTAR during an upgrade. I would look at using 11.5.7 which supposedly has a script that could check which scripts need not run.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details!

The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.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 Jul 01 2002 - 15:08:22 CDT