Re: Bigger blocksize on index TBS

On Jan 14, 6:47 am, Helma <helma.vi..._at_hotmail.com> wrote:
> On 14 jan, 14:54, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
> wrote:
>

>
> Thank you for the pointers. I've read opinions about the use of
> different blocksizes, but they were often anecdotical. I don't have
> the opportunity to test if it makes a difference - the database is
> just too big for such high impact experiments with low revenue
> expectations.
> I think i've got bigger fish to catch.
> thanks again,
> H.

One more con:

Eliminates your option of multiple buffer pools for anything in the TS in question.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11222

http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/memory.htm#i30935 (hey, 11g docs still mention hit ratios! ¡Ay Caramba! Take these docs with a margarita rimmed in salt.)

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080113/news_1m13litter.html