Re: Choosing a db_block_size for a 8i Datawarehouse ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 27 Sep 2002 22:51:38 +1000
Message-ID: <EkYk9.41128$g9.118026@newsfeeds.bigpond.com>

Hi Christian,

May I suggest checking out Steve Adam's website http://www.ixora.com .

In the tips section, he discusses the most appropriate block size depending on your environment.

Cheers

Richard
"Christian Svensson" <chse30_at_hotmail.com> wrote in message news:ccc2a7eb.0209270426.7ac82043_at_posting.google.com...
> Greetings all,
>
> In our staging database (~200Gb) for our Datawarehouse we have a great
> deal of large I/O intensive batch transaction where we do a lot of
> selects/inserts/deletes/updates between 200.000 - 400.000 rows each
> transaction in our ETL process. Later when all the
> validation/scrubbing is done, Cognos application selects approx 90
> milj of rows to its own files from where our users do the actual gets.
>
> Currently we use a block size of 8K but are thinking if choosing a
> higer block size.
>
> Environment:
> - Sun Solaris
> - Raid 0+1
> - 8.1.7
>
> Does anyone have any ideas or can recommend any good
> papers/articles/url:s of this topic ?
>
> Thanks a lot
>
> Cheers !
>
> /Christian Svensson
Received on Fri Sep 27 2002 - 07:51:38 CDT