Re: Redo block size...

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 15 Jan 2004 18:00:45 -0800
Message-ID: <73e20c6c.0401151800.42eb02a3@posting.google.com>

Holger Baer <holger.baer_at_science-computing.de> wrote in message news:<bu62bf$qpm$1_at_news.BelWue.DE>...

> > What filesystem would you recommend for the datafiles/redos on Linux RH? I've heard that
> > both, ext2 and ext3 are suitable.
> >

>
> according to this link, ext3 it is:
>
> http://www.quest-pipelines.com/newsletter-v2/linux2.htm

<careful>
According to that link, you can NOT derive that any of the file systems detailed there are better for redo.

The benchmarks do NOT discriminate between database datafiles (using a large block size typically >4K) and redo logfiles using MUCH SMALLER block sizes.

The results on that link assume that all writes in Oracle are of the same db block size. Nothing could be more wrong.

>
> And in the Oracle on Linux-Course, Oracle recommends using of ext3.

That's my gut feel too, but it's only that: a feel. Based on it being similar to ext2 plus having journaling (which prevents fsck problems at boot time). Debatable.

The link above has done nothing to confirm or deny which f/s is better for redo.
</careful>

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Thu Jan 15 2004 - 20:00:45 CST