Re: Bigger blocksize on index TBS
From: news.verizon.net <kennedyii_at_verizon.net>
Date: Mon, 14 Jan 2008 12:33:03 GMT
Message-ID: <3EIij.8796$W73.7413@trnddc04>
Date: Mon, 14 Jan 2008 12:33:03 GMT
Message-ID: <3EIij.8796$W73.7413@trnddc04>
"Helma" <helma.vinke_at_hotmail.com> wrote in message
news:8a3ea588-ab6a-42ea-b635-19fff25414fd_at_f47g2000hsd.googlegroups.com...
> Hello everyone,
>
> How to investigate in advance if a bigger blocksize on an index
> tablespace will benefit performance?
>
> Thanks for pointers
> H.
Test it. Remember that to have an index tablespace with a different block
size you have to explicitly allowate a cache for it. So if you get the
cache size wrong then you either waste memory (too large) or thrash the
cache.
Jim
Received on Mon Jan 14 2008 - 06:33:03 CST