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

Addendum:

One thing I have noticed in this any many other threads is this focus on block size by those with access problems. Why this single parameter focus?

My bet would be that a query of PCTFREE and PCTUSED on dba_tables would demonstrate that close to 50% of what is being read off the disk is vacuum: And index blocks are also saving space for updates that will never take place.

If you are going to ask the operating system to read 4K or 8K of disk ... try to make sure it is gettig as close to 4K or 8K of value.

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