Re: 8k block size upgrade concern

JeffV wrote:
> Daniel,
>
>
> Are you suggesting then that there should be a benefit to upgrading
> Oracle 4k to 8k since 8k matches the operating system block size?
>
> Thanks,
>
> Jeff

The default block size in Oracle should ALWAYS be the block size of the operating system, as installed, unless actual testing with your application and your data demonstrates otherwise.

The advice that has been given in a few books, a few magazines, and a lot of web postings about smaller blocks sizes for OLTP and larger for OLAP is not demonstrated by testing and should be ignored.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)