Hi,
I would like to ask related question ...
when I create table with ...
B1 BLOB SEGMENT SIZE x
then segment size x defines only in memory buffer, where blob data are
handled /retrieved from data pages or written back/ or it is used to
define
size of blob segments in on-disk ?

In table row is stored blob_id, which points to chunk of blob
segments,
which are stored in pages on disk.
So it is true, that one blob segment can be as large as large is page
(when
page_size is 4K, then one blob segment on disk can be 4K). So when for
example I store in blob picture, which is 16KB , then it will be
split into
4 segments=4 pages each of 4KB ?

May be on one data page stored blobs segments from 2 or 3 tables (can
be
mixed) ? Or one page can hold only blob from one table ?
Is there any minimum alocation for blob (for example 1 page) or if on
some
page (partialy used by other) is unused free space, then this space
may be
used ?

Thanks
-Laco.