Re: db block size, too big wasting buffer?

In article <af99ui$oj4$1_at_lust.ihug.co.nz>, you said (and I quote):

> Multiple block sizes were invented to enable transportable tablespaces to
> work properly (ie, transport between databases that were created with
> different block sizes). No doubt you can use them to do as you describe, but
> it will generally be an utterly inappropriate thing to do.
>
> There is no keep or recycle pool possible for a non-standard block size, so
> there's your first big performance penalty. SYSTEM and all temporary
> tablespaces must always be of the standard block size -so there's your next
> performance hit if you get that decision wrong.
>

Yup, very good points. The blurb about 9i initially made a lot of the multiple block sizes, but in all reality they are more (at this stage) to be used as you describe. One lives in hope, though... ;-)

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam