Re: Table with 300 columns (ie > 255) : Row Chaining ?
- From: Tanel Poder <tanel@xxxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Thu, 8 Oct 2009 21:43:55 +0300
If all row pieces fit into the same block (where the initial row piece is
written) then you'll have intra-block chaining. Basically chained rows,
where the "next row piece" pointer bytes will point into another row in the
same block. If they don't fit, then you have regular row chaining, into
other blocks too.
--
Tanel Poder
http://blog.tanelpoder.com
On Thu, Oct 8, 2009 at 6:08 PM, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>wrote:
>
>
> Is there a MetaLink note that explains how Oracle handles INSERTs into a
> table with more than 255 columns ?
> Is it broken into 2 row pieces ? Does Oracle write the pieces into
> separate blocks even if, say, the row length is less than 7000 bytes ? If
> the row length is less than 3900 bytes ?
>
>
>
Other related posts:
