Re: Bigger blocksize on index TBS
Date: Mon, 14 Jan 2008 04:57:21 -0800 (PST)
On Jan 14, 1:23 pm, Helma <helma.vi..._at_hotmail.com> wrote:
> Hello everyone,
> How to investigate in advance if a bigger blocksize on an index
> tablespace will benefit performance?
> Thanks for pointers
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 DBAReceived on Mon Jan 14 2008 - 06:57:21 CST