| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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: TBall_at_birch.com
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: 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). Received on Fri Aug 23 2002 - 11:48:33 CDT
 |
 |