Re: Block size qn

From: Bob-W1TI <w1ti_at_comcast.net>
Date: Wed, 10 Jun 2020 11:26:52 -0400
Message-ID: <a2588554-806c-02a5-8713-3cab15d127da_at_comcast.net>


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
Received on Wed Jun 10 2020 - 17:26:52 CEST

Original text of this message