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@xxxxxxxxxxx> 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
//www.freelists.org/webpage/oracle-l
