Re: LOB questions

I'm interested in this. How does the second question depend on block size? I assume you mean Oracle block, not OS block size? Since this is something new, I can't find much info on the Internet. I read Mike Ault's fairly well-known paper "Going out for the LOB". It doesn't help, performance-wise.

Thank you.

Yong Huang
yhuang_at_indigopool.com

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message news:969398533.29498.0.nnrp-04.9e984b29_at_news.demon.co.uk...
> [snipped]
> 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 - 17:19:52 CDT