Re: Re: larger block sizes
Quote:
Originally posted by slimdave
Mike, this comment intrigues me, as it implies to me that you believe that a test on a 32bit version of Oracle would not be valid, or something?
it is that you cannot create 32k blocks on 32 bit OS's (I cannot :(
but it does beg the question how he knows it'll show a 1/3 increase in performance but that is another story. (usually you run a benchmark to discover the results, not announce the results you'll BE benchmarking in the future? that is how it has worked for me in the past, that the results were found after the benchmark was run)
Once upon a time ago, these 32k blocks had a special name...
BOB - the Big Oracle Block, it was for the incredible addressing space of 64bit.
if you google for
"big oracle block"
you'll get one hit (like magic, until and if this page gets indexed).
We used to have an option call the VLM option (Very Large Memory) for this support -- not around anymore, but you need 64bit to get 32k blocks.
I think though that Microsoft came out with MS Bob and we backed off. Something like that.