Re: Change db_block_size

In a valiant and sublime effort,Howard J. Rogers dipped a thumbnail in soot and doodled:

>useful feature. First, there's no keep or recycle pools for new block
>sizes, only for the one you started out with.

Let's hope that makes it to the next version...

> And second, there *is* a
>"correct" block size for your operating system and file system, and picking
>any other one will impact on performance.
>

Sure. But what about databases where you HAVE to keep BLOB/CLOB stuff as well as other normal data? I'd rather have a TS reserved for the large data with a large block size and the rest with an optimal block size for normal processing. That way I can keep the BLOB stuff from upsetting the performance of the rest of my data cache.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Oct 13 2001 - 07:01:55 CDT