Re: Oracle CLOB

From: joel garry <joel-garry_at_home.com>
Date: Wed, 29 Sep 2010 15:47:53 -0700 (PDT)
Message-ID: <1f340ee8-d11d-433a-8cfd-5519618914d8_at_13g2000prf.googlegroups.com>

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]

Usual caveats about information from the intertubes apply.

jg

--
_at_home.com is bogus.
"Only amateurs attack machines; professionals target people." - Bruce
Schneier, as quoted in http://catless.ncl.ac.uk/Risks/26.17.html#subj13

Received on Wed Sep 29 2010 - 17:47:53 CDT