Re: Bigger blocksize on index TBS

From: sybrandb <>
Date: Mon, 14 Jan 2008 04:57:21 -0800 (PST)
Message-ID: <>

On Jan 14, 1:23 pm, Helma <> wrote:
> Hello everyone,
> How to investigate in advance if a bigger blocksize on an index
> tablespace will benefit performance?
> Thanks for pointers
> H.

It will NOT benefit performance. There will be less I/O, but blocks will be bigger: the number of bytes being read will be identical. This has been recently concluded from a post by Don Burleson on OTN, promoting bigger blocksizes, which was exposed by Jonathan Lewis and Richard Foote as an incorrect assertion.

Sybrand Bakker
Senior Oracle DBA
Received on Mon Jan 14 2008 - 06:57:21 CST

Original text of this message