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).
