Slight correction: the URL is http://www.ixora.com.au :)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:EkYk9.41128$g9.118026_at_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 - 08:38:48 CDT
