Re: design question, use of partitioned tables?

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 7 Aug 2003 16:53:58 +0300
Message-ID: <3f3259f7$1_1@news.estpak.ee>

"Nuno Souto" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0308061946.188c36a3_at_posting.google.com...
> "Tanel Poder" <tanel@@peldik.com> wrote in message
news:<3f31758d_1_at_news.estpak.ee>...
>
> > Also check your lob chunk size, if most of your millions of lobs are 4k
in
> > size for example, you will waste much space and IO bandwidth when having
8k
> > chunk size (min chunk size is Oracle block size).
>
> You mean default chunk size, not "min"?

Hi!

Actually I should have been a little more specific. When inline storage is enabled, then LOBs up to 3964 bytes can be stored in-line and nothing is allocated in LOB segments for them, thus CHUNK size doesn't matter at all. But for out of line LOBs the minimum allocation (chunk) is one database block *per lob item*. So, the minimum is db block size, but you can specify larger chunk as well if you want.

Tanel. Received on Thu Aug 07 2003 - 08:53:58 CDT