RE: 8.1.7 instance on Solaris periodically goes sluggish, then hangs...

Paul,

Make sure you're on the lastest 8.1.7.4 patch level.

Learn about 10046 extended SQL tracing. Then, arrange for one or two of those users who have been complaining to call you as soon as they notice something fishy and turn on the tracing. This will show you in more detail than you might care about what is causing the wait.

TOAD and Spotlight are useless in these circumstances.

Gudmundur

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Paul Vincent
> Sent: 28. júlí 2003 13:40
> To: Multiple recipients of list ORACLE-L
> 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: Gudmundur Bjarni Josepsson
  INET: gbj_at_index.is

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