RE: Average size of reads from online redo logs by ARCH process

Alex,
you could strace the arch process to get detailed numbers. The read = size is dependent on the underlying file system setup (i.e. raw devices, = veritas file system or unix/windows file system). There is not direct = relationship to the buffer_size for read (or write). check out steve = adams site for some detailed info on redo i/o = http://www.ixora.com.au/notes/

just curious, why do you care about the *read* size? the average = *write* size can be calculated from :

select value from v$sysstat where name=3D'redo blocks written'; /
select value from v$sysstat where name=3D'redo writes';

a log block size is os dependent as shown in = http://www.ixora.com.au/notes/log_block_size.htm

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alexandre Gorbatchev Sent: Tuesday, November 16, 2004 9:12 AM To: oracle-l_at_freelists.org
Subject: Average size of reads from online redo logs by ARCH process

Hi all,
How do I figure out what is the average (or constant?) size of disk = reads=20
from online logs by ARCH process?
Is there any relation to _log_archive_buffer_size? It is 2048 log blocks =

by default, as far as I know, so on my platform it's 2Mb.

Thanks in advance,
Alex

--

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

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 16 2004 - 12:02:45 CST