Re: Fast access to a BLOB

I'd have to read the manual to check, but I think LOBs (and varrays) of less that about 4K are stored in line..

You might want to rebuild the database to  blocks of 8K to get fewer I/Os per large size LOB.

You might also look at the paramters relating to CHUNKSIZE

The index should make the most immediate difference though.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Matthias Späth wrote in message <7m74re$20k2$1_at_news.karlsruhe.punkt.de>...


>>

>I read in the documentation that in line are only stored locators and the

>LOB data is out of line.

>Does Oracle store data with a size of less then 2k (for instance) in line


>and data greater then 2k out of line ?





>db_block_size = 2048

>LOB size is random (100Byte to 1MB)