Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)
Received on Sat Jul 10 1999 - 05:41:18 CDT