Redo write statistics

From: Terrian, Thomas J Mr CTR DLA J6DIB <Tom.Terrian.ctr_at_dla.mil>
Date: Thu, 25 Sep 2008 08:36:17 -0400
Message-ID: <82E215DEED1C8344BF94BBF276A1FB24077989AB@COL1SMX11.USE.AD.DLA.MIL>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 25 2008 - 07:36:17 CDT

Original text of this message