Re: Oracle CLOB
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 30 Sep 2010 19:53:09 +0200
Message-ID: <4ca4ce85$0$14260$ba620e4c_at_news.skynet.be>
joel garry wrote:
> On Sep 29, 9:37 am, "Gerard H. Pille"<g..._at_skynet.be> wrote:
>> Since this thread is read by serious people too:
>>
>> today one of our developers ran into "not enough space" when filling a table with a lob column.
>>
>> He didn't understand how this happened, he had no way entered enough data to fill the tablespace.
>>
>> I checked, and the lobsegment was taking 240Mb for some 60Mb of data (sum(dbms_lob.getlength()).
>> I moved the lobsegment to another tablespace, and doing so the segment shrank to 100Mb.
>>
>> What should I do to prevent this waste of space?
>>
>> Thanks,
>>
>> Gerard
>
> There have been discussions in various places about this, I don't have
> time to find the relevant ones, but here's a start:
>
> http://jonathanlewis.wordpress.com/2007/05/11/lob-sizing/
> MOS How to determine the actual size of the LOB segments and how to
> free the deleted/unused space above/below the HWM [ID 386341.1]
Date: Thu, 30 Sep 2010 19:53:09 +0200
Message-ID: <4ca4ce85$0$14260$ba620e4c_at_news.skynet.be>
joel garry wrote:
> On Sep 29, 9:37 am, "Gerard H. Pille"<g..._at_skynet.be> wrote:
>> Since this thread is read by serious people too:
>>
>> today one of our developers ran into "not enough space" when filling a table with a lob column.
>>
>> He didn't understand how this happened, he had no way entered enough data to fill the tablespace.
>>
>> I checked, and the lobsegment was taking 240Mb for some 60Mb of data (sum(dbms_lob.getlength()).
>> I moved the lobsegment to another tablespace, and doing so the segment shrank to 100Mb.
>>
>> What should I do to prevent this waste of space?
>>
>> Thanks,
>>
>> Gerard
>
> There have been discussions in various places about this, I don't have
> time to find the relevant ones, but here's a start:
>
> http://jonathanlewis.wordpress.com/2007/05/11/lob-sizing/
> MOS How to determine the actual size of the LOB segments and how to
> free the deleted/unused space above/below the HWM [ID 386341.1]
So my getlength on a UTF8 database could be missing half the bytes, and I need to get rid of ASSM (see my thread in c.d.o.s). Received on Thu Sep 30 2010 - 12:53:09 CDT