what bugs are those? > > From: Jack van Zanen <[EMAIL PROTECTED]> > Date: 2003/07/28 Mon AM 11:09:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha > > Plus if you are on 8.1.7.3 you have several bugs that can cause hangs w/o > alert log messages. (check metalink) > > Jack > > > -----Original Message----- > Sent: Monday, July 28, 2003 4:04 PM > To: Multiple recipients of list ORACLE-L > hangs... > > > run statspack and check your top 5 wait events. you have some kind of > bottleneck flairing up. > > > > From: "Paul Vincent" <[EMAIL PROTECTED]> > > Date: 2003/07/28 Mon AM 09:39:30 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: 8.1.7 instance on Solaris periodically goes sluggish, then > > hangs... > > > > Hi, > > > > rather vague, this one, I'm afraid, but we're stumped for ideas. > > > > We have an Oracle 8.1.7 instance on a Sun Solaris setup, which we're > > currently testing prior to going live. Every so often - 2 or 3 times a > > week - the users phone to say the application has stopped responding. > > They're waiting several minutes with no response. We find we can > > usually fire up one or two tuning apps, such as TOAD or Quest's > > Spotlight, but within a few minutes, these also stop responding. By > > this time, even trying to fire up a SQL*Plus session from my PC just > > hangs and hangs, without the login ever completing. We always end up > > having to get the sysadmin to abort-shutdown Oracle and then restart > > it. After which everything's fine - until the next time. > > > > I've checked the PROCESSES parameter, and this is set to 150 - way > > above the maximum number of connections we've seen (around 40 or so). > > Likewise SESSIONS and TRANSACTIONS parameters seem generously > > adequate. The sysadmin says the server itself doesn't seem to be > > having any problems. He can log in and run UNIX commands with no > > apparent performance problems. > > > > Any ideas at all would be very welcome! > > > > Paul Vincent > > Oracle DBA > > University of Central England > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Paul Vincent > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: Jack van Zanen > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
