Re: Redo block size...

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<bu5ubf$1qc$1_at_news.fujitsu-siemens.com>...
> Hi!
> Nest month I have a chance to reconfigure the io system of one of our db servers.
> How do I find out the chunk size in which redo information is written to disk?

Oracle 9.2.0.3.0 on RedHat 8.0.
Extfs3 filesystems, 4KB for datafile volumes.

SQL> select distinct block_size from v$archived_log;

BLOCK_SIZE

       512

The redo log buffer is flushed when it is 1/3 full, on commit, when it hits 1 MB and when numerous other events occur that post to it.

If you check out a statspack report, you will see a systat named "redo wastage".
examine that with respect to "redo size" and you should have a good idea as to how efficient your redo generation to disk is with respect to storage space.

Pd Received on Thu Jan 15 2004 - 11:21:31 CST