Paul - What I've found to be the most helpful is to install Oracle's
STATSPACK (included free with your Oracle). Then when you receive the first
report of sluggishness, take a STATSPACK snapshot. About 5 minutes later,
take another. It takes a snapshot of what is going on with your database at
that time, including the wait statistics so you can see what your database
was waiting on. Best of all, it just takes a moment, so you can spend time
telling the users that everything will be well soon.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, July 28, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
hangs...
Paul
Checked the Following
1) Are there any error in the Alert.log file
2) 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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/28/03 09:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
