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>
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-lReceived on Thu Sep 25 2008 - 07:36:17 CDT