Redo write statistics

From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 25 Sep 2008 08:36:17 -0400

I am trying to determine how fast it takes to write a block from the
redo log buffer to the redo logs.  If I am understanding the statistics
in v$sysstat properly, in order to return the number of milliseconds per
block write the equation should be as follows:

select (a.value*10/b.value)  
from v$sysstat a, v$sysstat b
where a.name = 'redo write time' 
and b.name = 'redo blocks written';

However, the number I am getting back is quite small (around 0.087).
Shouldn't a write be around 2 to 10 ms?  What am I missing here?

Thanks,
Tom

--
//www.freelists.org/webpage/oracle-l

Redo write statistics

Other related posts: