Hi,

Firstly i will describe problem symptoms and after that i will give software and hardware informations.

I think that we have problems with writing to online redo logs.
We have such messages in trace files (SID_lgwr_2120.trc):

*** 2008-08-30 07:00:14.285
Warning: log write time 820ms, size 2KB
*** 2008-08-31 10:21:08.646
Warning: log write time 550ms, size 9KB
*** 2008-09-01 03:15:11.876
Warning: log write time 860ms, size 0KB
*** 2008-09-01 14:51:05.904

---------------------------------------------------------------
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) :


Total ----------------- % of Waits ------------------
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----
LGWR wait for redo copy 19 100.0
Log archive I/O 78 1.3 1.3 62.8 34.6

-------------


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 ?

Best Regards Arek Masny