RE: How to store CLOBS without wasting storage space

Well, check the user_segments , get the right LOB & LOBindex segments and look for
their extents into user_extents. That will tell you how much storage is allocated to the lob segments. It is usually the same thing that you specify in
your storage clause.
-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: Monday, May 15, 2000 3:24 AM
To: Multiple recipients of list ORACLE-L Subject: 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,
Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).