Re: Redo block size...

"Paul Drake" <drak0nian_at_yahoo.com> schrieb im Newsbeitrag news:1ac7c7b3.0401150921.4b078d0f_at_posting.google.com...
> "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

Is the same for me. Ok, I guess it's kinda hard to distribute that across two disks.

> If you check out a statspack report, you will see a systat named "redo
> wastage".

Will do.
> 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.

Ok. I'll also check whether there's some indicator on how much redo is written on average per lgwr action.

Thanks a lot!
Volker Received on Thu Jan 15 2004 - 11:51:20 CST