Re: Block size qn

both row and execution time.  this beast is constantly being fed via outside as well as inside sources; and reporting going on.

We experimented with the different block sizes and came up with this mix.  fwiw, the dw is currently 20tb and growing.

On 6/10/20 11:44 AM, Orlando L wrote:
> 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
> <mailto: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