On 1/17/07, Nuno Souto <dbvision@xxxxxxxxxxxx> wrote:
You might need to consider a smaller block size, IF a large percentage of your LOBs is slightly over the 4K "jump to offline" boundary and nowhere near the 8K block size. By this of course I mean: test the smaller block size with real data. Start at 2K?
let say i have LOB data average 100K how if I set blocksize for LOB tablespace is 32K? but my database wide blocksize is 8K, how about performance? another things are: some LOB size per row will be vary 100MB, 500MB or even 1.2GB how we set the blocksize in related to performance. regards ujang -- http://www.freelists.org/webpage/oracle-l