Terry - My vote would be to try and track down which users are pounding your
system at that time and ask what the heck they are doing. Once you have a
handle on the "what" and "who", then the steps you need to take become
clearer. I've had weird problems like this clear up by locating the user and
telling them to "cut it out". Sometimes the answer is that they can't, but
sometimes a small adjustment on their part can rectify issues.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, August 26, 2002 10:48 AM
To: Multiple recipients of list ORACLE-L
I finally got the SAs to turn on and check trace files. It is indicating
that the file system that contains both the TEMP tablespace and the RBS
tablespace is 99 - 100% busy during the 15 minutes prior to 15 minutes after
the alert log warning.
I am looking at seperating the two tablespaces. But would it help to make
the logs smaller? They are currently at 20M each.
Any other options I should look at?
TIA
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-----Original Message-----
Sent: Friday, August 23, 2002 3:27 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent on behalf of a colleague...
Are there any messages in /var/adm/messages (or wherever they have syslogd
pointing to)?
What about the volume manager logs?
It may be related in some way to some other bugs:
Check problems: 4501030 and 4341008 in this patch
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fpatches%2F108528&zone_32=Or
acle%20aiowait
http://sunsolve.sun.com/pub-cgi/findPatch.pl?patchId=109688&rev=01
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert%2F23633&zone_32=asyn
c%20I%2FO&wholewords=on
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert%2F28311&zone_32=Orac
le%20aiowait
Other things that might be interesting to you/others:
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F45203&zone_32=async%
20I%2FO&wholewords=on
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F40043&zone_32=Oracle
%20I%2FO
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F27049&zone_32=Oracle
%20I%2FO
http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsrdb%2F27574&zone_32=Oracle
%20I%2FO
-----Original Message-----
Sent: Friday, August 23, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Users hadn't even noticed it was happening. The only reason it was caught
was because we have BMC's Patrol setup to monitor the DB and when this
happens, Patrol alarms.
-----Original Message-----
Sent: Friday, August 23, 2002 1:37 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
I've never encountered this particular problem, but I would be
strongly inclined to turn off async IO and use multiple db writers.
Your statement that "the database isn't crashing" is highly subjective.
Ask your users if they agree.
Jraed
"Ball, Terry" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/23/2002 09:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Strange experience
Oracle 8.1.7.4 on Solaris 8.
We upgraded from 8.1.6.3 to 8.1.7.4 last month. Since the upgrade, we
have
seen the occasional strange problem since. At approx. the same time (but
not
daily), there will be an entry in the alert.log
WARNING: aiowait timed out 1 times
At the same time as the warning is entered into the alert log, all of the
sql connections to the database are dropped. The background processes
stay
active, but the any other processes die.
According to Metalink, this error should also be followed by a DB crash,
which is _not_ what is happening. Metalink also says that Async IO should
be turned off and multiple DBWRs should be started. SInce the database
isn't crashing, there is some reluctance to turn off Async IO.
Has anyone else seen anything like this? And if so, how have you handled
it?
TIA for any help that can be provided.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
