Re: 9i multi cache buffer

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 18 Nov 2002 07:13:06 +1100
Message-ID: <WCSB9.78569$g9.221206@newsfeeds.bigpond.com>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3dd7f53d_1_at_mk-nntp-
> All of which is why, when people ask "What block size should I use?",
> I answer:
>
> a) Insufficient data. What are your objectives/OS platform/DB
> version/application characteristics?
>

Too many degrees of freedom. You need only ask "OS Platform".

;-)

> or
>
> b) It depends
>

...on the O/S platform.

> or (failing everything else)
>
> 8K.

Hmmm. It will do. Unless you're on AIX or Linux or NT.

:-)
HJR
> Over-simplification, I know, but it answers the question.
>
> In any case, in real life it's usually the crappy SQL that makes the
> difference.
>
> Regards,
> Paul
>
>
>
Received on Sun Nov 17 2002 - 14:13:06 CST