Tracy, We ran into some similar problems. Oracle will want you to obtain several system state dumps when the system is hung (we were still able to do this connected internally through server manager). With my limited expertise in reading state dumps the symptoms appeared to be severe latch contention to the point that the system appeared hung. Evidently there was significant re-writes in this area from 8.0 to 8.1 and there have been several attempts to resolve these problems (some introducing new problems). If you can issolate the latch from the state dumps, you can try metalink again and specify the latch name. You may have better luck finding a bug similar to the one you are experiencing searching with the latch name and/or specifying performance. There are several for differing latches.
Of the ones in metalink, several were either closed as not reproducable, or marked as fixed in one release or another (although some of those were identical to ours). In our situation, the problem did not occur unless we were attempting to do an online consistent export of our PeopleSoft financials database (the method we use for copying the database, not for backups). We got around the problem by kicking everyone out of the database during exports. As we had a viable work around and I did not want to deal with oracle support, we simply did not pursue it with them. Bill --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Tracy - Two ideas: > On Metalink, get note 61552.1 Diagnosing Database > Hanging Issues > I would try to run STATSPACK (or utlbstat/utlestat) > while the > database is hanging. You can also run STATSPACK on a > schedule. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Tuesday, April 30, 2002 2:22 PM > To: Multiple recipients of list ORACLE-L > > > I have opened a TAR with Oracle and am waiting a > resolution. In the > meantime, > I am wondering if anybody else has any ideas while I > wait. > > Specifics: > IBM AIX 4.3 > Rdms 8.1.7.3 > Database ~75g > OLTP database with approximately 500 dedicated > connections and 500 shared > connections with Oracle's MTS. > > Problem: > The database hangs, and no user is able to connect > to the instance, except > locally through srvmgrl. Even within svrmgrl, we are > unable to select > anything from > the > database without the query hanging. However, we can > abort the instance > (shutdown abort) and start it up again just fine. > This has happened on > 4-22, 4-29 & > 4-30 in the > early afternoon. Usually, this is also our peak > busy rate for the week. We > are executing MTS for 4 applications, all other > applications connect through > dedicated server. > The alert log contains a message unable to start a > shared server process. > This week it was #41 and last week it was #25. > Normally, we do not exceed 5 > shared > servers. Another thing I noticed is that there is > no time allocated to any > of the newly created shared servers. It is as if, > it can not process any > work > through existing shared > servers and decides to allocate another one, until > finally it freezes. I am > not sure if this is a MTS problem because I would > suspect that I should be > able > to establish > a dedicated server connection. And I can not. I > think that this is just a > symptom of the underlying problem. It would appear > to me that we are > running out > of a resource, > however our sysadms do not see any resource > problems. Does anybody have any > ideas how to debug this? Thanks > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Tracy Rahmlow > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).