Re: LOB segment space usage

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 17 Aug 2007 16:29:50 +0200
Message-ID: <46C5B0DE.7050209@gmail.com>

andreik schrieb:

> So why did it need to use 3 blocks (that's 6144 bytes) instead of just
> 1 to store the poor 2048 bytes?

As yourself mentioned, the data will be stored in the fixed width UCS2(like) character set, that means, you store not 2048 bytes, but 2048 characters, each of them requires 2 bytes of storage. You can probably see it if you follow the advice from Sybrand and dump your blocks, or may be you would like to read a nice white paper from Tanel Põder
http://integrid.info/Poder_LOB_Internals.pdf about LOB internals.

Best regards

Maxim Received on Fri Aug 17 2007 - 09:29:50 CDT