Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h0V0NEx32033 for ; Thu, 30 Jan 2003 18:23:14 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h0V0NEm32028 for ; Thu, 30 Jan 2003 18:23:14 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA51060; Thu, 30 Jan 2003 13:06:39 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0053F8B6; Thu, 30 Jan 2003 12:34:12 -0800 Message-ID: Date: Thu, 30 Jan 2003 12:34:12 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Nick Wagner Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Nick Wagner Subject: RE: investigating database lockup Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C89E.C887DBD0" ------_=_NextPart_001_01C2C89E.C887DBD0 Content-Type: text/plain; charset="iso-8859-1" Do you have Oracle 9i Supplemental logging turned on? Also information about high water mark, and extent information, data dictionary upkeep... what are the stats of the table storage clause? -----Original Message----- Sent: Thursday, January 30, 2003 11:43 AM To: Multiple recipients of list ORACLE-L This morning I have experienced a couple of strange lockups of our database. The symptoms were the database was nonresponsive to any activity, freeze on login to sqlplus, active sessions freeze as soon as they interact with the db. There is no alert log activity. The systems cpu usage soars to 100%, and an oracle process, once a shared server and once a dedicated server, is dominating the usage(info gathered from top). The first time I killed the shared server process, and the database picked up and operated normally. Then a half hour later the dedicated connection popped up. The dedicated connection was owned by one of our oltp processes that pretty well runs without issue 24/7, so I decided to bounce the db to hopefully clear up the issue. Our system is Oracle 8.1.7 on Solaris 8. In short, I am hoping to get some ideas in tracking down what happened. I have some sql scripts that I have used to identify problem sessions/sql in the past. They focus on v$session, v$sess_io, and v$sqltext. Unfortunately, these did me little good because while the trouble was occurring I couldn't interact with the database while the sessions were active. I am soliciting actively for any Hints, Tips, or Ideas you may have, Thanks, Steve McClure ------_=_NextPart_001_01C2C89E.C887DBD0 Content-Type: text/html; charset="iso-8859-1" RE: Debate on rc commands Solaris and Oracle
Do you have Oracle 9i Supplemental logging turned on?
 
Also information about high water mark, and extent information, data dictionary upkeep...   what are the stats of the table storage clause?
-----Original Message-----
From: Steve McClure [mailto:smcclure@usscript.com]
Sent: Thursday, January 30, 2003 11:43 AM
To: Multiple recipients of list ORACLE-L
Subject: investigating database lockup

This morning I have experienced a couple of strange lockups of our database.  The symptoms were the database was nonresponsive to any activity, freeze on login to sqlplus, active sessions freeze as soon as they interact with the db.  There is no alert log activity.  The systems cpu usage soars to 100%, and an oracle process, once a shared server and once a dedicated server, is dominating the usage(info gathered from top). 
 
The first time I killed the shared server process, and the database picked up and operated normally.  Then a half hour later the dedicated connection popped up.  The dedicated connection was owned by one of our oltp processes that pretty well runs without issue 24/7, so I decided to bounce the db to hopefully clear up the issue.
 
Our system is Oracle 8.1.7 on Solaris 8.   In short, I am hoping to get some ideas in tracking down what happened.  I have some sql scripts that I have used to identify problem sessions/sql in the past.  They focus on v$session, v$sess_io, and v$sqltext.  Unfortunately, these did me little good because while the trouble was occurring I couldn't interact with the database while the sessions were active.
 
I am soliciting actively for any Hints, Tips, or Ideas you may have,
 
Thanks,
Steve McClure
------_=_NextPart_001_01C2C89E.C887DBD0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nick Wagner INET: Nick.Wagner@quest.com 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@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).