Re: lob storage/performance

Depends how you want to use your LOBs and data. An out of line LOB always takes a CHUNK, and the minimum chunk size is a block. For LOBs of 0.5-1K you waste a lot of space by disabling storage in row.

On the other hand, if you have to scan the table to find the data in the 7 columns that tells you which LOB you want, then you have to scan a lot more space. So there is no automatically right answer to your question

In 8.1 the LOB segment and LOB Index have to be in the same tablespace.

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

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



susana73_at_hotmail.com wrote in message <94siic$84v$1_at_nnrp1.deja.com>...


>Hi,

>

>I have a table that has 10 columns with 3 CLOBs.  Developers are


>complaining performance is very slow.  So I am looking into recreating

>the table with new storage parameters for CLOB.  I got couple questions:

>

>1. What should the CHUNK size be set?  My CLOB is around 0.5K - 1K in

>byte.  My db block size is 4K.  The CLOB is accessed very frequently.

>

>2. Does 'disable storage in row' increase performance?

>

>3. Is the LOB and the LOB index supposed to reside in the same or

>different tablespace?

>

>Thanks very much.

>

>Susan

>

>

>Sent via Deja.com

>http://www.deja.com/