Re: Redo log block size on 11.2
From: joel garry <joel-garry_at_home.com>
Date: Wed, 2 Nov 2011 15:54:15 -0700 (PDT)
Message-ID: <344bc639-5186-4d7b-890b-779661abf96c_at_m5g2000prg.googlegroups.com>
On Nov 2, 1:12 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Oracle 11.2 allows the DBA to define the block size for redo logs:
>
> http://tinyurl.com/6co7u2e
>
> The DBA guide is mostly concerned with the redo wastage. The available
> options are 512B, 1K and 4K. The 4K size is recommended for the newer
> disks, with 4K sector. On Linux, however, the vast majority of file
> systems use 4K blocks which leads me to the conclusion that there would
> be better blocking factor for large ETL type operations with 4K redo log
> block size. Did anyone experiment with that? Are there any experiences
> whatsoever?
>
> --http://mgogala.byethost5.com
Date: Wed, 2 Nov 2011 15:54:15 -0700 (PDT)
Message-ID: <344bc639-5186-4d7b-890b-779661abf96c_at_m5g2000prg.googlegroups.com>
On Nov 2, 1:12 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> Oracle 11.2 allows the DBA to define the block size for redo logs:
>
> http://tinyurl.com/6co7u2e
>
> The DBA guide is mostly concerned with the redo wastage. The available
> options are 512B, 1K and 4K. The 4K size is recommended for the newer
> disks, with 4K sector. On Linux, however, the vast majority of file
> systems use 4K blocks which leads me to the conclusion that there would
> be better blocking factor for large ETL type operations with 4K redo log
> block size. Did anyone experiment with that? Are there any experiences
> whatsoever?
>
> --http://mgogala.byethost5.com
Of course, I have no experience and don't know much about it, but the first thing that strikes me is, wouldn't it be based on the disk itself, whether it uses emulation mode? I'm thinking this option would be a way of getting around filesystems hiding it from Oracle.
jg
-- _at_home.com is bogus. People want to port vms to x86? http://searchoracle.techtarget.com/news/2240106448/Oracle-HP-should-graduate-from-kindergarten-user-saysReceived on Wed Nov 02 2011 - 17:54:15 CDT