Oracle-L: Re: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Mon, 28 Jul 2003 06:49:24 -0800
Message-ID: <F001.005C779F.20030728064924@fatcity.com>

Hi!

Yep it could very well be an crashing/stuck archiver process problem. When instance is restarted by sysadmin, archiver is started again and it archives online logs allowing further DML to be made and redo to be generated.

Also, when users phone you next time, try to tnsping your service, to see whether network and listener are ok. Next thing is trying to log on as sysdba, these connections can log on even when no more redo can't be generated. Then select event from v$session_wait and see on what most events are waiting for.

Tanel.

Original Message ----- From: Indy Johal To: Multiple recipients of list ORACLE-L Sent: Monday, July 28, 2003 5:04 PM Subject: Re: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...

Paul

Checked the Following

Are there any error in the Alert.log file
Are the Database in Archivelog mode and the Log_archive_start is not marked true and so it might be hanging after all of the Redologs are been filled as Archiver is not running.

Thanks
Indy Johal

       "Paul Vincent" <Paul.Vincent_at_uce.ac.uk> 
        Sent by: ml-errors_at_fatcity.com 
        07/28/03 09:39 AM 
        Please respond to ORACLE-L 

               
                To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
                cc:         
                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: Tanel Poder
INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------