Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha

RE: 8.1.7 instance on Solaris periodically goes sluggish, then ha

From: Jack van Zanen <JACK_at_quantsystems.nl>
Date: Mon, 28 Jul 2003 07:09:30 -0800
Message-ID: <F001.005C77AA.20030728070930@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US