Re: Block size qn

Thanks Bob. Is that a typical DW type with loads in the nights with queries in the days? Was 16K chosen because 8K could not accommodate one full row or was there another reason?

On Wed, Jun 10, 2020 at 10:28 AM Bob-W1TI <w1ti_at_comcast.net> wrote:

> we use 16k for all data and 32k for indexes. seems to work quite well.
> been in this mode for over 10 yrs.
>
> bob
>
> On 6/10/20 11:14 AM, Orlando L wrote:
> > Hi,
> > We are in planning stages for a big DW. Do any of the listers have a
> > block size bigger than the default 8k in their site? Is there a need
> > for anything like that? Any advantages or pitfalls?
> >
> > Thanks,
> > Orlando
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l