Re: Bigger blocksize on index TBS
From: sybrandb <sybrandb_at_gmail.com>
Date: Mon, 14 Jan 2008 04:57:21 -0800 (PST)
Message-ID: <f8469d48-a6f8-4bdb-8af0-448e57f6f4e6@s12g2000prg.googlegroups.com>
Date: Mon, 14 Jan 2008 04:57:21 -0800 (PST)
Message-ID: <f8469d48-a6f8-4bdb-8af0-448e57f6f4e6@s12g2000prg.googlegroups.com>
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
> 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 DBAReceived on Mon Jan 14 2008 - 06:57:21 CST