Re: Bigger blocksize on index TBS

From: joel garry <>
Date: Mon, 14 Jan 2008 10:31:50 -0800 (PST)
Message-ID: <>

On Jan 14, 6:47 am, Helma <> wrote:
> On 14 jan, 14:54, "Jonathan Lewis" <>
> 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. (hey, 11g docs still mention hit ratios! ĦAy Caramba! Take these docs with a margarita rimmed in salt.)


-- is bogus.
Received on Mon Jan 14 2008 - 12:31:50 CST

Original text of this message