Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Mon Jul 28 2003 - 10:09:30 CDT
![]() |
![]() |