Re: LOB questions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 19 Sep 2000 22:13:42 +0100
Message-ID: <969398533.29498.0.nnrp-04.9e984b29@news.demon.co.uk>

If the LOB is 'not in use' it could be a null value, or an 'empty lob' depending how your application behaves - the former takes no space, the latter takes 40 - 80 bytes I think.

The second question depends on your block size and the LOB CHUNK size. Be careful of setting a large CHUNK size when you
expect to handle only small LOBs.

--

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

fly13_at_my-deja.com wrote in message <8q7sj8$iss$1_at_nnrp1.deja.com>...


>Hi all,

>

>I have few questions about LOB storing.

>-The first one is : If i am in DISABLE STORAGE IN ROW mode, is the a

>storage location busy if there is no LOB data for the row.

>-The second one : if i have LOB which size is about 4k, does the

>performance will be very much better if i use this DISABLE STORAGE IN

>ROW mode than storing data in-line.

>

>Cheers

>

>Fly13

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.

Received on Tue Sep 19 2000 - 16:13:42 CDT