Re: Block size qn

From: Bob-W1TI <w1ti@xxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 10 Jun 2020 11:26:52 -0400

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

Follow-Ups:
- Re: Block size qn
  - From: Orlando L

References:
- Block size qn
  - From: Orlando L

Other related posts:

» Block size qn- Orlando L
» RE: Block size qn- Noveljic Nenad
» Re: Block size qn - Bob-W1TI
» Re: Block size qn- Orlando L
» Re: Block size qn- Bob-W1TI
» Re: Block size qn- Neil Chandler
» RE: Block size qn- Herring, Dave
» Re: Block size qn- Andy Klock
» Re: Block size qn- Mladen Gogala
» Re: Block size qn- Jonathan Lewis
» Re: Block size qn- Orlando L
» Re: Block size qn- Neil Chandler
» RE: Block size qn- Mark W. Farnham
» Re: Block size qn- Orlando L
» Re: Block size qn- Mark J. Bobak
» Re: Block size qn- Orlando L
» Re: Block size qn- Orlando L
» Re: Block size qn- Ahmed Aangour
» Re: Block size qn- Jonathan Lewis
» Re: Block size qn- Ahmed Aangour
» Re: Block size qn- Jonathan Lewis
» Re: Block size qn- Ahmed Aangour