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 ** -- //www.freelists.org/webpage/oracle-l
Hemant K Chitale http://hemantoracledba.blogspot.com -- //www.freelists.org/webpage/oracle-l