---------------------------------------------------------------
I know what oracle says about this kind of messages.
I've even created SR on metalink, they said me the same.
They don't give solutions for free and i think that this is still problem.
So i'm looking for advice on this forum.
Next
In statspack we have sth like this (i can't analize that) :
We have application which uses this database and two of processes of this application fail with message in event viewer. I think that this is caused by problems with writing to online redo logs (or generally some IO problems maybe ?)
---------
NOW SOME FACTS ABOUT ENVIRONMENT :
We have 10g SE (10.2.0.4) on windows 2003 Server Standard.
Computer hardware is :
-DISC : RAID PERC 3/Di configured as RAID-1
-Bus speed (processor - memory) : 133MHz
-Two processors : 993Mhz
-2GB RAM.
I think that there is no many transactions on this database :
If transactions number may be measured as time between switching redo logs, it occurs at most every 20 minutes (redo logs size : 80 MB and log buffer size : 8 MB). Another way, sql trace file on main process has 40MB after 5 hours (maybe this is "stupid" way of measuring transactions factor, Sorry)
and additionally RAID-1 is efficient as i have heard.
All database files are located on the same Disc configuration (RAID-1).
--------
So, i need some advice what can i do with this kind of issue ?
What should i check ?
Do You have some experiences in this area ?