Re: Table with 300 columns (ie > 255) : Row Chaining ?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 21 Oct 2009 22:00:41 +0800
Message-Id: <200910211400.n9LE0cTl010325_at_smtp42.singnet.com.sg>


John,

Thanks. Yes, that is also mentioned in ML#1062906.6 . However, as I show
at
<http://hemantoracledba.blogspot.com/2009/10/some-testing-on-intra-block-row.html>http://hemantoracledba.blogspot.com/2009/10/some-testing-on-intra-block-row.html

I see 2 'consistent gets' if I select the 96th or higher column while I see 1 'consistent get' for the 95th or lower column. Christian explains that in terms of the row pieces being stored in reverse order.

Hemant

At 06:42 AM Wednesday, John Kanagaraj wrote:
>Hi Hemant,
>
> > Your test table has 350 columns. A row piece can store at most 255
> > columns.
>
>Just to add to this discussion, the answer is in the Concepts manual
>(10gR2 Concepts - Chapter 5 Schema Objects):
>
>--
>John Kanagaraj <><
>http://www.linkedin.com/in/johnkanagaraj
>http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
>** The opinions and facts contained in this message are entirely mine
>and do not reflect those of my employer or customers **
>--
>http://www.freelists.org/webpage/oracle-l

Hemant K Chitale

http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 21 2009 - 09:00:41 CDT

Original text of this message