How to store CLOBS without wasting storage space

I have a simple table (docnum char(10), content clob). The table takes about 8000 rows. The complete size of the clob is about 15MB. I created the table (include the LOB storage) with the following storage parameters:

  initial 2M next 2M pctincrease 1

With these settings I want to know how much storage is really allocated. After loading the data with sqlldr I can see that the lob segment of the table has grown up to 42 MB. This is about three time more the data it holds really.

How can I minimize this waste of storage space when using blobs ?

Thanks, Received on Mon May 15 2000 - 01:09:04 CDT