Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 36 first bytes of a lob: meaning ?

Re: 36 first bytes of a lob: meaning ?

From: kvmb <kvmb_at_nospam.com>
Date: Sat, 02 Sep 2006 12:09:59 GMT
Message-ID: <rweKg.54759$6B3.857201@phobos.telenet-ops.be>


Check out Tanel's paper on LOB internals : http://integrid.info/Poder_LOB_Internals.pdf

cheers,
Kurt

"Spendius" <spendius_at_muchomail.com> wrote in message news:1157185172.906395.34960_at_m79g2000cwm.googlegroups.com...
> Hi,
> I've noticed when you do a block dump that there are
> 36 extra bytes at the beginning of a lob field (and
> the length of the lob returned by DBMS_LOB.GETLENGTH
> substracts these 36 bytes from its result), even if it's
> empty, so the length shown in a trace file is always
> length of data + 36.
> Someone knows what these byte are about ? Does it
> depend on the block size ?
>
> Thanks.
> Spendius
>
Received on Sat Sep 02 2006 - 07:09:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US