what bugs are those?
>
> From: Jack van Zanen <JACK_at_quantsystems.nl>
> Date: 2003/07/28 Mon AM 11:09:30 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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" <Paul.Vincent_at_uce.ac.uk>
> > Date: 2003/07/28 Mon AM 09:39:30 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > 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: Paul.Vincent_at_uce.ac.uk
> >
> > 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: 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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> 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: 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
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: 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 28 2003 - 12:04:25 CDT
