Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: db block size, too big wasting buffer?
In article <BGh*ckHrp_at_news.chiark.greenend.org.uk>, you said (and I
quote):
> Having said that, in the benchmark fantasy-land, people are using
> multiple block sizes e.g. in:
Hey, if it works for them who am I to complain?
>
> Given the comments here though, and the fact we try to run our benchmarks
> as close to a realistic production configuration as possible, I think
> I'll hold off using that trick for a while at least.
Very wise. I'd wait until the buffer configuration for the extra block sizes allows for nifty stuff like the multiple classes. Or the ideal: one buffer class/group per tablespace per block size. Why the heck doesn't Oracle just bite the bullet and do it? They know they'll have to go that way, DB2 already has it...
-- Cheers Nuno Souto nsouto_at_optushome.com.au.nospamReceived on Tue Jun 25 2002 - 10:03:45 CDT