Re: Bigger block sizes
From: Michael Cunningham <napacunningham_at_gmail.com>
Date: Thu, 1 Oct 2015 08:48:38 -0700
Message-ID: <CAPt39tuMTe23rJePyDmtV2wt_+EtKNZ7wyRWP6=wxYof=UudNQ_at_mail.gmail.com>
Orlando,
Date: Thu, 1 Oct 2015 08:48:38 -0700
Message-ID: <CAPt39tuMTe23rJePyDmtV2wt_+EtKNZ7wyRWP6=wxYof=UudNQ_at_mail.gmail.com>
Orlando,
a few years ago I did some performance testing of this on a data warehouse. Creating the database with 32k block sizes (so I only had one block size) did give me better performance. I don't have the details with me since I letf that job, but it worked well for us.
Michael
On Wed, Sep 30, 2015 at 2:29 PM, Orlando L <oralrnr_at_gmail.com> wrote:
> List,
>
> Does anyone in the list use non default blocksize of greater than 8K for
> your oracle DBs; if so, is it for warehousing/OLAP type applications? What
> advantages do you get with them; any disadvantage.
>
> Orlando.
>
-- Michael Cunningham -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 01 2015 - 17:48:38 CEST